ON , , . , .
OFF , , , .
ON , ON.
(CURSOR_CLOSE_ON_COMMIT)
, . True False. True, , . False, . False, , INSENSITIVE STATIC.
(CURSOR_DEFAULT)
. LOCAL, LOCAL , , . . GLOBAL, Transact-SQL .
ANSI NULL (ANSI_NULL_DEFAULT)
(=) (<>) NULL. True (.) False (.).
ANSI NULL (ANSI_NULLS)
(=) (<>) NULL. - True (.) False (.). True, NULL UNKNOWN. False, , , NULL True, NULL.
ANSI (ANSI_PADDING)
ANSI. True (.) False (.).
ANSI (ANSI_WARNINGS)
ISO . True, , ( SUM, AVG, MAX, MIN, STDEV, STDEVP, VAR, VARP COUNT) NULL. False, .
(ARITHABORT)
, . - True False. True, . , . False, , , , .
|
|
NULL NULL (CONCAT_NULL_YIELDS_NULL)
NULL. True, string + NULL NULL. False string.
(DATE_CORRELATION_OPTIMIZATION)
True SQL Server , FOREIGN KEY datetime.
False .