Curriculum
Course: SQL
Login

Curriculum

SQL

SQL Tutorial

0/42

SQL Database

0/20

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

MS Access Functions

0/67

SQL Quick Ref

0/1
Text lesson

SESSIONPROPERTY

Example

Retrieve the session configuration or properties for a specified option.

SELECT SESSIONPROPERTY(‘ANSI_NULLS’);

Definition and Usage

The SESSIONPROPERTY() function retrieves the session settings for a specified option in SQL Server.

Syntax

SESSIONPROPERTY(option)

Parameter Values

Parameter

Description

option

Mandatory. Specifies the session setting option to retrieve. Options include:

  • ANSI_NULLS
  • ANSI_PADDING
  • ANSI_WARNINGS
  • ARITHABORT
  • CONCAT_NULL_YIELDS_NULL
  • NUMERIC_ROUNDABORT
  • QUOTED_IDENTIFIER

 

Technical Details

Works in:

 SQL Server (from 2008 onward), Azure SQL Database

 

 

 

Previous
Next