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 |
|
tzgz5s
Starting Member
3 Posts |
 Posted - 2005-05-19 : 02:25:03
|
| Hi,I have a loop that creates a string to be used later to create a ##-temporary table with a variable number of columns. The string variable @String varchar(4000) is concatenated with a new column definiton each round. However, @String never gets longer that 256 characters although the loop seems to work fine and there is no error messages given. Does someone know the reason for this? |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-05-19 : 02:31:56
|
Is this in QA?The default maximum characters per column is 256 - display purposes only. Thats why it works but the @string seems concatenated.You can change this by going to Tools >> Options >> Results tabIf this isnt the case then can you give more detailAndyBeauty is in the eyes of the beerholder  |
 |
|
|
tzgz5s
Starting Member
3 Posts |
Posted - 2005-05-19 : 02:41:56
|
quote:
Originally posted by AndyB13
Is this in QA?The default maximum characters per column is 256 - display purposes only. Thats why it works but the @string seems concatenated.You can change this by going to Tools >> Options >> Results tabIf this isnt the case then can you give more detailAndyBeauty is in the eyes of the beerholder
|
|
|
|
tzgz5s
Starting Member
3 Posts |
Posted - 2005-05-19 : 02:42:53
|
quote:
Originally posted by AndyB13
Is this in QA?The default maximum characters per column is 256 - display purposes only. Thats why it works but the @string seems concatenated.You can change this by going to Tools >> Options >> Results tabIf this isnt the case then can you give more detailAndyBeauty is in the eyes of the beerholder
Thansk, Andy, my problem is gone! |
|
|
|
|
|
|
String conacatenation limitations?