asked on

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.

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

folderol

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aneesh

in order to change this from the default value of 256 to 8092,

tools -> options->result
No of characters per column to 8092

SOLUTION

LandyJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LandyJ

Sorry, meant to say the default is to display... (Shoulda refreshed before hitting enter)

Aneesh

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

RyanBank

ASKER

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)

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial