Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SESSIONPROPERTY (Transact-SQL)

Returns the SET options settings of a session.

Topic link icon Transact-SQL Syntax Conventions


SESSIONPROPERTY (option)
option

Is the current option setting for this session. option can be any of the following values.

Option

Description

ANSI_NULLS

Specifies whether the ISO behavior of equals (=) and not equal to (<>) against null values is applied.

1 = ON

0 = OFF

ANSI_PADDING

Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks in character and binary data.

1 = ON

0 = OFF

ANSI_WARNINGS

Specifies whether the ISO standard behavior of raising error messages or warnings for certain conditions, including divide-by-zero and arithmetic overflow, is applied.

1 = ON

0 = OFF

ARITHABORT

Determines whether a query is ended when an overflow or a divide-by-zero error occurs during query execution.

1 = ON

0 = OFF

CONCAT_NULL_YIELDS_ NULL

Controls whether concatenation results are treated as null or empty string values.

1 = ON

0 = OFF

NUMERIC_ROUNDABORT

Specifies whether error messages and warnings are generated when rounding in an expression causes a loss of precision.

1 = ON

0 = OFF

QUOTED_IDENTIFIER

Specifies whether ISO rules about how to use quotation marks to delimit identifiers and literal strings are to be followed.

1 = ON

0 = OFF

<Any other string>

NULL = Input is not valid.

sql_variant

SET options are figured by combining server-level, database-level, and user-specified options.

The following example returns the setting for the CONCAT_NULL_YIELDS_NULL option.

SELECT   SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.