SESSIONPROPERTY (Transact-SQL)

Returns the SET options settings of a session.

Topic link iconTransact-SQL Syntax Conventions

Syntax

SESSIONPROPERTY (option)

Arguments

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

    Option Description

    ANSI_NULLS

    Specifies whether the SQL-92 compliant 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 SQL-92 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 SQL-92 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.

Return Types

sql_variant

Remarks

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

Examples

The following example returns the setting for the CONCAT_NULL_YIELDS_NULL option.

SELECT   SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')

See Also

Reference

sql_variant (Transact-SQL)
SET ANSI_NULLS (Transact-SQL)
SET ANSI_PADDING (Transact-SQL)
SET ANSI_WARNINGS (Transact-SQL)
SET ARITHABORT (Transact-SQL)
SET CONCAT_NULL_YIELDS_NULL (Transact-SQL)
SET NUMERIC_ROUNDABORT (Transact-SQL)
SET QUOTED_IDENTIFIER (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance