Chapter 9 SQL Statements
607
SET statement [T-SQL]
Use this statement to set database options for the current connection in an
Adaptive Server Enterprise-compatible manner.
SET
option-name
option-value
None.
None.
"SET OPTION statement" on page 612
"Setting options for Transact-SQL compatibility" on page 969 of the book
ASA User’s Guide
"Transact-SQL and SQL/92 compatibility options" on page 163
The available options are as follows:
Option name Option value
ANSINULL
ON | OFF
ANSI_PERMISSIONS
ON | OFF
CLOSE_ON_ENDTRANS
ON | OFF
QUOTED_IDENTIFIER
ON | OFF
ROWCOUNT
integer
SELF_RECURSION
ON | OFF
STRING_RTRUNCATION
ON | OFF
TEXTSIZE
integer
TRANSACTION ISOLATION LEVEL
0 | 1 | 2 | 3
Database options in Adaptive Server Anywhere are set using the SET
OPTION statement. However, Adaptive Server Anywhere also provides
support for the Adaptive Server Enterprise SET statement for options that are
particularly useful for compatibility.
The following options can be set using the Transact-SQL SET statement in
Adaptive Server Anywhere as well as in Adaptive Server Enterprise:
♦
SET ANSINULL { ON | OFF } The default behavior for comparing
values to NULL in Adaptive Server Anywhere and Adaptive Server
Enterprise is different. Setting ANSINULL to OFF provides Transact-
SQL compatible comparisons with NULL.
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...