Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nucleus_03
Starting Member
1 Post |
 Posted - 2004-03-10 : 12:12:43
|
| I have an sql statement which I'm running through SQL 2000 that fails when the number of characters in the SQL statement nears 8400 or so (failure on exact number of characters is not consistent) characters . The syntax is correct. Any suggestions? While the statement is below the documented 64K sql statement limit it still fails.Thanks in advance.Shawn |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-03-10 : 13:59:56
|
quote:
Originally posted by nucleus_03
The syntax is correct.
I respectfully disagreeThat's got to be 1 hell of a statement though...Are you using column names fully qualified with the table name btw?Just curious...Brett8-) |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-10 : 14:27:06
|
 Post the script.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-03-10 : 14:33:46
|
| are you using dynamice sql and building a varhcar() string? the max limit of a varchar() is 8000 chars, so it may be getting truncated.Either way, never forget: TABLE ALIASES will go a LONG way towards making your SQL shorter, easier to write and most importantly easier to read.- Jeff |
|
|
|
|
|
|
SQL2000: Large Query gets Incorrect Syntax error