Beefy Boxes and Bandwidth Generously Provided by pair Networks
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 ( #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

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://663024]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2020-10-28 20:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (264 votes). Check out past polls.

    Notices?