document updated 14 years ago, on Dec 17, 2009
Sometimes you want to run VERY LONG SQL queries. Some issues you encounter while doing this:
- SP2-0027 error [input is too long > 2499 characters - line ignored]
- add newlines in the middle of the query — a single SQL statement can be much longer than 2499 characters, but no single line of text in that query can be longer than that
(make sure you use the PROPER newlines — if you use the wrong one, it won't recognize it)