SQL Server SESSIONPROPERTY() Function

Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server SESSIONPROPERTY() Function
❮ SQL Server Functions
Example
Return the session settings for a specified option:
SELECT SESSIONPROPERTY('ANSI_NULLS');Definition and Usage
The SESSIONPROPERTY() function returns the session settings for a specified option.
Syntax
SESSIONPROPERTY(option)Parameter Values
| Parameter | Description |
|---|---|
| option | Required. The option to retrieve the session settings for. Can be one of the following values:
|
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database |
|---|
❮ SQL Server Functions