in reply to Re^2: need to parse firts part of SQL-query (regex question)
in thread need to parse firts part of SQL-query (regex question)
I used this to parse SQL source files for over a thousand stored procedures and check that the case of variables, columns, etc. matched when moving a system from a case-insensitive dataserver to a case-sensitive one. It required doing quite a bit of hand-coding to handle the various language elements of Transact-SQL, and ended up with about 700 lines of code to do all the checks, but I mostly got it done...
Michael
|
|---|