Table 2-2 lists the set options that affect Transact-SQL output. For more information, see set in the Adaptive Server Enterprise Reference Manual.
set Option |
Default |
Meaning |
---|---|---|
char_convert |
Off |
Turns character-set conversion off and on between Adaptive Server and a client; also starts a conversion between the server character set and a different client character set. |
fipsflagger |
Off |
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. |
flushmessage |
Off |
Sends messages as they are generated. |
language |
us_english |
Sets the language for system messages. |
nocount |
Off |
Turns off report of number of rows affected. |
noexec |
Off |
Compiles each query but does not execute it; often used with showplan. |
parseonly |
Off |
Checks the syntax of queries and returns error messages without compiling or executing the queries. |
showplan |
Off |
Generates a description of the processing plan for a query; does not print results when used inside a stored procedure or trigger. |
statistics io statistics time |
Off |
Displays performance statistics after each execution. |
statistics subquerycache |
Off |
Displays the number of cache hits, misses, and rows in the subquery cache for each subquery. |
textsize |
32K |
Controls the number of bytes of text or image data returned. |