Free Resources from FMS

Additional Resources

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

 

Free Catalog

 

Displaying Longer Results in SQL Query Analyzer

Provided by: Molly Pell, Technical Project Manager

By default, SQL Query Analyzer only displays the first 256 characters for each column's value. Follow these steps to display up to 8192 characters per column:

 

From the SQL Query Analyzer menu, select Tools -> Options:

On the Results tab, use the “Maximum characters per column” field to specify the maximum number of characters to display in an output column:

This value can be between 30 and 8192.

Note: This setting also affects the behavior of the Transact-SQL Debugger window.


Return to the tips page