Query Analyzer equivalent to Oracle SQL*Plus

Would you happen to know what the equivalent is for the following Oracle SQL commands, if any?

set linesize 100
column description format a30    -- description is the name of a column

In other words, can we format the Query Analyzer output?

Thanks!!
guillotjAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Or, for the specific code shown above:

SELECT CAST(description AS VARCHAR(30)), ...
...

AFAIK, there is no SQL Server equivalent to Oracle's "linesize" option.  Therefore, the description will be truncated at 30 chars, not continued onto following line(s).
0
 
Brian CroweDatabase AdministratorCommented:
SELECT ..., CAST(description AS varchar(100)) AS description, ...
FROM...
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.