Views in SQL

Question:
I have a text field in a table that returns the entire field when queried. As soon as I create a view in SQL Enterprise Manager though, the text is truncated immediately after the colon(:) and returns only the first part of the text message.

How do I have it return the entire text field?

Answer:
In Query Analyzer with version 7 and above, bump up the “maximum characters per column” setting. I believe it is set to 256 by default.

In SQL 2000, you can find this option under tools, options, and the results tab. Because I don’t have version 7 handy right now, I can’t tell you the exact place to change the setting in 7, but it is there too.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: