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