Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 3, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Views in SQL

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?

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date