devxlogo

Views in SQL

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist