Loading lesson path
Concept visual
Start at both ends
Return the session settings for a specified option:
SELECT SESSIONPROPERTY('ANSI_NULLS');The SESSIONPROPERTY() function returns the session settings for a specified option.
option )
Required. The option to retrieve the session settings for. Can be one of the following values: ANSI_NULLS ANSI_PADDING ANSI_WARNINGS
CONCAT_NULL_YIELDS_NULL NUMERIC_ROUNDABOUT QUOTED_IDENTIFIER
SQL Server (starting with 2008), Azure SQL Database
❮ SQL Server Functions