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 |
|
lane0618
Posting Yak Master
134 Posts |
 Posted - 2002-05-21 : 13:54:19
|
| I have a CSV variable that will not fit in varchar(8000). What datatype can I use that will work for string as large as 30,000 characters?Thanks!Lane |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-21 : 14:00:56
|
| TextI think it can store up to 2gigs worth in one line. |
 |
|
|
lane0618
Posting Yak Master
134 Posts |
Posted - 2002-05-21 : 14:06:02
|
| I think text is not valid for local variable, which is what I'm using it for. Any other suggestions?Thanks,Lane |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-21 : 14:12:19
|
| Is this variable going to be a param for a proc?the largest character datatype for a local variable is varchar(8000). you can cre8 a table to hold your text data in a column, or you can split up the data and use 4 varchar(8000) . . . or you can try to redesing your process so yo don't have the problem.<O> |
|
|
|
jbkayne
Posting Yak Master
100 Posts |
Posted - 2002-05-21 : 16:38:49
|
quote:
I think text is not valid for local variable, which is what I'm using it for. Any other suggestions?
You can pass a variable of datatype "text" to a stored procedure. |
|
|
|
|
|
|
varchar(8000)