set options can customize the display of results, show processing statistics, and provide other diagnostic aids for debugging your Transact-SQL programs.
Table 14-5 lists the global variables that contain information about the session options controlled by the set command.
Global variable |
Description |
|---|---|
@@char_convert |
Contains 0 if character set conversion is not in effect. Contains 1 if character set conversion is in effect. |
@@isolation |
Contains the current isolation level of the Transact-SQL program. @@isolation takes the value of the active level (0, 1, or 3). |
@@options |
Contains a hexadecimal representation of the session’s set options. |
@parallel_degree |
Contains the current maximum parallel degree setting. |
@@rowcount |
Contains the number of rows affected by the last query. @@rowcount is set to 0 by any command that does not return rows, such as an if, update, or delete statement. With cursors, @@rowcount represents the cumulative number of rows returned from the cursor result set to the client, up to the last fetch request. |
@scan_parallel_degree |
Contains the current maximum parallel degree setting for nonclustered index scans. |
@@textsize |
Contains the limit on the number of bytes of text or image data a select returns. Default limit is 32K bytes for isql; the default depends on the client software. Can be changed for a session with set textsize. |
@@tranchained |
Contains the current transaction mode of the Transact-SQL program. @@tranchained returns 0 for unchained or 1 for chained. |
The @@options global variable contains a hexadecimal representation of the session’s set options.Table 14-6 lists set options and values that work with @@options.
Numeric value |
Hexidecimal value |
set option |
|---|---|---|
4 |
0x04 |
showplan |
5 |
0x05 |
noexec |
6 |
0x06 |
arithignore |
8 |
0x08 |
arithabort |
13 |
0x0D |
control |
14 |
0x0E |
offsets |
15 |
0x0F |
statistics io and statistics time |
16 |
0x10 |
parseonly |
18 |
0x12 |
procid |
20 |
0x14 |
rowcount |
23 |
0x17 |
nocount |
For more information on session options, see the set command in the Reference Manual.
