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


No such thing as a small change
	PerlMonks

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

by mpeppler (Vicar)

on Jan 18, 2008 at 08:11 UTC ( [id://663024]=note: print w/replies, xml )

Need Help??

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