A number of set options affect Transact-SQL output.
| Option | Description |
|---|---|
char_convert | Turns character-set conversion off and on between the SAP ASE server and a
client; also starts a conversion between the server character set and a different client
character set. The default is off. |
fipsflagger | Warns when any Transact-SQL extensions to entry-level SQL92 are used.This option
does not disable the SQL extensions. Processing completes when you issue the non-ANSI
SQL command. The default is off. |
flushmessage | Sends messages as they are generated. The default is off. |
language | Sets the language for system messages. The default is us_english. |
nocount | Turns off report of number of rows affected. The default is off. |
noexec | Compiles each query but does not execute it; often used with
showplan. The default is off. |
parseonly | Checks the syntax of queries and returns error messages without compiling or
executing the queries. The default is off. |
showplan | Generates a description of the processing plan for a query; does not print results
when used inside a stored procedure or trigger. The default is off. |
statistics io, statistics time | Displays performance statistics after each execution. The default is off. |
statistics subquerycache | Displays the number of cache hits, misses, and rows in the subquery cache for each
subquery. The default is off. |
textsize | Controls the number of bytes of text or image data
returned. The default is 32K. |
For more information, see set in the Reference Manual