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)

Agreed - but this seems to me to be a good starting place.

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

  • Comment on Re^3: need to parse firts part of SQL-query (regex question)