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 |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-12-03 : 07:30:27
|
| hi all,i have to concatenate id of all a table that contains 1 lakh records.The size of each id is 10 characters. I have tried with the following codedeclare @string ntext but it is giving the following errorMsg 2739, Level 16,The text, ntext, and image data types are invalid for local variables.can anybody help me to solve this issuethanks in advance regards Durgesh J |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-12-03 : 08:27:13
|
Maybe you can tell about the whole problem you want to solve this way and maybe then here is someone to show a solution without concatenating (100,000 * 11 - 1) characters?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-03 : 09:36:57
|
quote:
Originally posted by DURGESH
hi all,i have to concatenate id of all a table that contains 1 lakh records.The size of each id is 10 characters. I have tried with the following codedeclare @string ntext but it is giving the following errorMsg 2739, Level 16,The text, ntext, and image data types are invalid for local variables.can anybody help me to solve this issuethanks in advance regards Durgesh J
how come your id is a text field?also whats the reason behind doing this? |
|
|
|
|
|
|
how to declare variable more than 8000 characters