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 |
|
OwnedByTheMan
Starting Member
35 Posts |
 Posted - 2001-01-18 : 13:19:40
|
| Is there an upper length limit on dynamically created statements (in this case, a SELECT with 3 distinct 'OR' portions making it rather long)?No matter what combination of delimiters etc I use, my dynamically created string keeps truncating at a point that, after expermimentation, seems to be based on length of the string created. The statement is SET into a varchar(8000), DECLARED var. |
|
|
|
|
|
Length limit on Dynamic SELECT's