Parse SQL Queries - Extract Join Criteria
Оплачивается при доставке
Sql Query Parse Join Columns.
I need a way to parse sql queries and build a list of [login to view URL] used in the join criteria.
1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file.
2-It needs to extract the join criteria from the queries.
3-It needs to format in a tab delimited file.
+Schema and table name written out (not alias) and combined.
4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file).
5-If the join is between a nested query (a derived table), that join does not need to be included. Only table to table.
6-The output file can not have duplicates across all columns.
It needs to be written in VB.NET 4.7+ Winforms Application.
You can use [login to view URL] library (they have trial) to do the parsing if needed.
It needs to be extremely accurate and smooth with good code.
Attached is an example and output format.
Max bid: 70
When submit bid, please answer: what day of the week is it? (to filter out fake bot bids!)
ID проекта: #37222441
22 фрилансеров(-а) готовы выполнить эту работу в среднем за $127
Hi there, I checked your requirements and guarantee you that i have relevant experience in SQL it's gonna be done within the next few hours . Let's contact via chat so that I can start work immediately