question

Suj_556 avatar image
Suj_556 asked

Problem with no of characters of data being displayed in Query Results window

My requirement is to display some tab delimit formatted text. When i try with "Results to Grid", data is being displayed in single row. Tab alignment is not applied. When i go with "Results to Text", data being displayed as required but getting truncated I found the max limit as 8192. Under Options->Query Results->Sql server->Results to text -> Max no of chars displayed in each col - 8192 Is there any solution to fix this problem
datatruncate
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
BTW, you should move this question to regular Questions & Answers forum. This forum is meant for internal site discussions only.
0 Likes 0 ·

1 Answer

·
Usman Butt avatar image
Usman Butt answered
You need to look into this spectacular SQL Spackle by Jeff Moden [Display More Than 8000 Characters][1]. [1]: http://www.sqlservercentral.com/articles/T-SQL/72129/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.