Things I Learned Today

All Things Enterprise Vault with a sprinkling of everything else

Menu
  • About Me
  • EV Videos
  • Windows Videos
  • Other Videos
Menu

Altering text output in SQL Select Statements

Posted on June 12, 2008 by Rob Wilcox

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.

1 thought on “Altering text output in SQL Select Statements”

  1. Denny says:
    July 11, 2008 at 6:48 pm

    Thanks, Rob. I can use this info.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Have a look at more of my instagrams

robwilc

Instagram post 2191883967647582565_6386916 @ponchthemalshi getting ready to ruuuuun on the #beach
Instagram post 2191346228925688393_6386916 @ponchthemalshi says he absolutely has to chase the sand that @art.cw20 kicked into the sea
Instagram post 2190627531479228057_6386916 Outdoor cinema in Perth.
Instagram post 2188372971561844120_6386916 Great walking along the #beach #nofilter
Instagram post 2187018555017594204_6386916 Inside Fremantle Prison
Follow on Instagram
  • Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
© 2019 Things I Learned Today | Powered by Minimalist Blog WordPress Theme