August 27, 2002 at 2:46 pm
Another question for you SQL guru's:
SQL 2000 will only display the first 255 characters of a varchar, even though it goes up to 8000. I'm trying to figure out how I can get the rest of the text to show. I have searched the msg boards and found some information on doing this with a text data type, but I wanted to know specifically for the varchar data type. Any help would be appreciated. Thanks.
August 27, 2002 at 2:52 pm
If you're using Query Analyzer, it's because QA is only set to show the first 255 characters. Here's an article I wrote which will help:
http://www.sqlservercentral.com/columnists/bkelley/qa2k_3_1.asp
On the results tab, you want to change the Maximum Characters per column to a number higher than 256. The maximum setting is 8192.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 27, 2002 at 2:54 pm
Thanks so much for the quick reply.
August 28, 2002 at 2:46 am
Or in query analyzer you can select "result in text" option to show full field value....
Cheers,
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
August 28, 2002 at 3:37 am
Result in text will not affect the "Maximum Characters per column" which is in effect on the column output. You will still be limited in that column unless you change the value.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply