SQL Server SESSIONPROPERTY() Function
❮ SQL Server Functions
Example
Return the setting for a specified option of a session:
SELECT SESSIONPROPERTY('ANSI_NULLS');
Definition and Usage
The SESSIONPROPERTY() function returns the setting for a specified option of a session.
Syntax
Parameter Values
| Parameter |
Description |
| option |
Required. The option to retrieve the session settings for. Can be one of
the following values:
| Option |
Description |
| ANSI_NULLS | SQL-92 compliant behavior of NULL values. 1=ON,
0=OFF |
| ANSI_PADDING | SQL-92 compliant behavior of padding and
trailing spaces in storage of character and binary columns. 1=ON, 0=OFF |
| ANSI_WARNINGS | SQL-92 compliant behavior of warnings and
error messages. 1=ON, 0=OFF |
| ARITHABORT | Abort queries when an overflow or divide-by-error
occurs. 1=ON, 0=OFF |
| CONCAT_NULL_YIELDS_NULL | Concatenated results (that are NULL)
are treated as NULL rather than empty strings. 1=ON, 0=OFF |
| NUMERIC_ROUNDABOUT | Warnings and error messages are raised
when rounding causes a loss of precision. 1=ON, 0=OFF |
| QUOTED_IDENTIFIER | SQL-92 compliant behavior of quotation
marks to delimit literal strings and identifiers. 1=ON, 0=OFF |
|
❮ SQL Server Functions
