Table 2-2: set options that affect Transact-SQL output
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.
|
