• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Jun 122008
 

Something I learnt today, which surprised me… When you do a select statement and it includes a wide text column SQL Query Analyzer truncates that by default to 256 characters.

To get around this go in to SQL Query Analyzer, then go to Tools -> Option, and click on the Results tab. You will see an entry saying :

Maximum characters per column: 256

Change that value, and hey presto it will show you a much wider column.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

  One Response to “Altering text output in SQL Select Statements”

  1. Thanks, Rob. I can use this info.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)