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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2009-03-30 : 14:45:36
|
| What is the limit on the length of a string (which is comma delimited list) that can be passed to a stored proc in SQLserver 2005 and 2000? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-30 : 15:12:25
|
| For 2000 , use varchar - max is 8000 . I would advise varchar rather than text , as you can use string operations. You could exceed this , by breaking it down as part1 , part2 , part 3 etc For 2005 , there is a new data type called VARCHAR(MAX)Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
question