|
|
SESSIONPROPERTY
Display the SET options currently set for a session.
Syntax:
SESSIONPROPERTY ( propertyname )
For boolean values SessionProperty will return 1 for ON or 0 for OFF.
Examples
SELECT SESSIONPROPERTY ('ANSI_NULLS')
SELECT SESSIONPROPERTY ('ANSI_PADDING')
SELECT SESSIONPROPERTY ('ANSI_WARNINGS')
SELECT SESSIONPROPERTY ('ARITHABORT')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_ NULL')
SELECT SESSIONPROPERTY ('NUMERIC_ROUNDABORT')
SELECT SESSIONPROPERTY ('QUOTED_IDENTIFIER')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
"Riches do not consist in the possession of treasures, but in the use made of them" - Napoleon Bonaparte
Related commands:
