Query analyzer text limit

hi,

Is there a limit to displaying charecters using QA?

declare @myVar as varchar (8000)
....
print (@myVar+@myvar1+@myvar2+@myvar3+@myvar4+@myvar5)

Thanks.
RyanBankAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
the maximum characters per column is 8092
0
 
folderolConnect With a Mentor Commented:
Go to Tools, Options, Results and see what you have for max column width.

Tom
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
in order to change this from the default value of 256  to 8092,

tools -> options->result
No of characters per column to 8092
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
LandyJConnect With a Mentor Commented:
QA will display only about the first 1000 or so characters of a field in the result pane.  The data is still there, it just truncates it in the display.  The SQL field limit is 8092.
0
 
LandyJCommented:
Sorry, meant to say the default is to display...  (Shoulda refreshed before hitting enter)
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
LandyJ,
> QA will display only about the first 1000 or so characters of a field  in the result pane.

If you go to the Text Mode option, it will display 8000 characters
0
 
RyanBankAuthor Commented:
i also found out that is was print command that had a limit now sure what the limit is, but when i split into groups of print command everything displayed in QA.

print(@MyVar1)
print(@MyVar2)
print(@MyVar3)
print(@MyVar4)
0
 
Anthony PerkinsConnect With a Mentor Commented:
>>i also found out that is was print command that had a limit now sure what the limit is,<<
If you read aneeshattingal's original comment in response to your question, it clearly states:
"the maximum characters per column is 8092"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.