setting query's output in ms sql 6.5

[bibyjord]

Hi,

we have a query that have to return more than 255 char per row, does anybody know how we can force ms sql to display us more than 255 char ?

Our result is about 2000 char per row...

Thanks in advance for any help you may give us.

regards, Roberto

 

[tlbroadbent]

You must be using Query Analyzer.

In SQL 2000: Select Options from the Tools menu. Click on the Results Tab. Change Maximum characters per column to 2000 or whatever value you want.

I don't recall if the process is exactly the same for SQL 7. It will be similar though accessible through a different menu selection.

You can specify text size in a query with the SET TEXTSIZE command. SET TEXTSIZE specifies the size of text and ntext data returned with a SELECT statement. Se SQL BOL for details. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[tlbroadbent]

Wow. I should have read the subject. My answer doesn't apply in SQL 6.5. Sorry about that. I don't have an answer for 6.5 though you might check the ISQL/W options. Checl SQL BOL to see if SET TEXTSIZE exists. I just don't recall. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[bibyjord]

Thanks Terry.

I've found on sql bol (I think you mean 'book on line', don't you?...) the global variable @@textsize; I've modified it but my output don't change.

I think the problem may be that I've inserted on the select list a big series of 'comments'...my query's something like this...
select 'comment1'+field1+'comment2'+field2'+......+'commentn'+'fieldn'....from.....where.....
and they 'eat' my poor 255 chars of output....

On the isql/w tool there's no option that can help me....I've tried to use also another tool (winsql) but also that tool don't have any helpful settings...

Thanks for your support.
ciao Roberto