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 |
|
mrsaif
Starting Member
43 Posts |
 Posted - 2005-12-27 : 11:00:32
|
hi,in my stored prcedure i have a string which contains Ids(comma seprated value) like this '1,2,3,4,5,612,12,4'. this string might be longer than 8000 character so i cannot use varchar or nvarchar as they limit to 8000 characters.so what i decided to user text datatype provided by the sql server 2000. i can use len and charindex substring functions that can be applied to varchar to extract these ids one by one . How can this be done in text datatype. what should i do to get ids indvidually like '1' '2' '3' .. etc. form this text type stored procedure variable? IS is possible or i should see som othere way to do thatif other why then what should be the best way pleas help.?  Muhammad Saifullah |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
using text data type as stored procedure parameter