Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL Server SESSIONPROPERTY() Function?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ SESSIONPROPERTY('ANSI_NULLS');3Order
Put the learning moves in the order that makes the concept easiest to apply.
Return the session settings for a specified option:
Definition and Usage
SQL Server SESSIONPROPERTY() Function
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: ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT CONCAT_NULL_YIELDS_NULL NUMERIC_ROUNDABOUT QUOTED_IDENTIFIER |
- ANSI_NULLS
- ANSI_PADDING
- ANSI_WARNINGS
- ARITHABORT
- CONCAT_NULL_YIELDS_NULL
- NUMERIC_ROUNDABOUT
- QUOTED_IDENTIFIER
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database |
|---|