query analazer limiting 256 characters row data

20 Jan 2005 3:17 PM

TreeView Custom

hi
i am using below query
select distinct 1 as tag,null as parent ,categoryid as
[products1!2!categoryid],productname as [products1!1!productname] from
products1 for xml explicit

but the query return more than 256 characters that i was not able to view in
query analyzer

is there any way can to view all records in query analyzer with truncating.

if solution available can u send the solution

pelase eagaerly waiting for your reply

regards
Sri

20 Jan 2005 3:20 PM

Yih-Yoon Lee

Go to Tools-Options, then results tab. There is a setting 'Maximum
Characters per column'. The max you can set is 8192

Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.onl***@gmail.com
/* remove .online to send me e-mail */

TreeView Custom wrote:
Show quote

> hi
> i am using below query
> select distinct 1 as tag,null as parent ,categoryid as
> [products1!2!categoryid],productname as [products1!1!productname] from
> products1 for xml explicit
>
> but the query return more than 256 characters that i was not able to view in
> query analyzer
>
> is there any way can to view all records in query analyzer with truncating.
>
> if solution available can u send the solution
>
> pelase eagaerly waiting for your reply
>
> regards
> Sri
>
>
>
>