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 |
|
shakana
Starting Member
6 Posts |
 Posted - 2004-09-08 : 18:00:57
|
| I am concatenating a sql string but it seems to have a limit of about 257 characters. The variable is declared as varchar(2000). Is there anyway to get around this?-Andre |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 18:03:43
|
| The limit is 8000. Is this only happening in Query Analyzer? If so, Tools..Options..Results..Maximum Characters Per Column.Tara |
 |
|
|
DustinMichaels
Constraint Violating Yak Guru
464 Posts |
Posted - 2004-09-08 : 18:04:35
|
| Thats strange. My only guess is that your viewing the result in query analyzer and that it is truncating the result. |
|
|
|
shakana
Starting Member
6 Posts |
Posted - 2004-09-08 : 18:19:32
|
| My max was set to 255. Thanks. |
|
|
|
|
|
|
Limit of string in stored procedures