Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parsing SQLs
to explain further, i have a table with a column (created_by) which should be populated with the CURRENT USER, but there are some rows where the column's data is that of the CURRENT PUBLISHER instead of the CURRENT USER so i'm creating a script that'll traverse through the sql files that... -
Parsing SQLs
basically, i have these sql files in the file system, and i would like to recurse through them and check the insert statement if the correct value (let's say, deptA) is being inserted in the column (department). -
Parsing SQLs
Hi Group, I have a bunch of SQL files and would like to check the insert statements if they're inserting the correct value in the correct column. insert into table (col1, col2, ... target_col .. coln) values (col1, col2, ... target_col .. coln)
