Display more than 256 characters of a column in SQL

Posted Date: 01 Jul 2009	Resource Type: Tips	Category: General
Author: Viji RAJKUMAR	Member Level: Diamond
Rating:	Points: 3

How to display more than 256 characters in a column in SQL Query Analyzer?

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:

1) Goto SQL Query Analyzer menu

2) Select Tools -> Options:

3) Click on Results tab

4. Set the “Maximum characters per column” field to specify the maximum number of characters to display in an output column

5. This value can be between 30 and 8192

Note:

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

For more details, visit http://vijirajkumar.blogspot.com/2009/07/display-more-than-256-characters-of.html

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Displaying Longer Results in SQL Query Analyzer . Display more than 256 characters of a column in SQL .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Verify your sql server account using command prompt
	Previous Resource: Microsoft Windows Shortcut Keys
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources