Other SESSIONPROPERTY SQL function
1. Usage of SESSIONPROPERTY
SQL Server Query 1
SELECT SESSIONPROPERTY('ANSI_NULLS') AS SessionProperty_ANSI_NULLS,
SESSIONPROPERTY('ANSI_PADDING') AS SessionProperty_ANSI_PADDING,
SESSIONPROPERTY('ANSI_WARNINGS') AS SessionProperty_ANSI_WARNINGS,
SESSIONPROPERTY('ARITHABORT') AS SessionProperty_ARITHABORT,
SESSIONPROPERTY('CONCAT_NULL_YIELDS_NULL') AS SessionPropertyCONCAT_NULL_YIELDS_NULL,
CASE WHEN SESSIONPROPERTY('NUMERIC_ROUNDABOUT') IS NULL
THEN 0
ELSE 1
END AS SessionProperty_NUMERIC_ROUNDABOUT,
SESSIONPROPERTY('QUOTED_IDENTIFIER') AS SessionProperty_QUOTED_IDENTIFIER;
Create SQL query with SqlQueryBuilder 1
var (sql1, parameters1) = new SqlQueryBuilder()
.Select()
.Column(new SESSIONPROPERTY(SessionPropertyOptions.ANSI_NULLS), "SessionProperty_ANSI_NULLS")
.Column(new SESSIONPROPERTY(SessionPropertyOptions.ANSI_PADDING), "SessionProperty_ANSI_PADDING")
.Column(new SESSIONPROPERTY(SessionPropertyOptions.ANSI_WARNINGS), "SessionProperty_ANSI_WARNINGS")
.Column(new SESSIONPROPERTY(SessionPropertyOptions.ARITHABORT), "SessionProperty_ARITHABORT")
.Column(new SESSIONPROPERTY(SessionPropertyOptions.CONCAT_NULL_YIELDS_NULL), "SessionProperty_CONCAT_NULL_YIELDS_NULL")
.Column(new CASE()
.When(new IS_NULL(new SESSIONPROPERTY(SessionPropertyOptions.NUMERIC_ROUNDABOUT)))
.Then(0)
.Else(1), "SessionProperty_NUMERIC_ROUNDABOUT")
.Column(new SESSIONPROPERTY(SessionPropertyOptions.QUOTED_IDENTIFIER), "SessionProperty_QUOTED_IDENTIFIER")
.Build();
Query build by SqlQueryBuilder 1
SELECT SESSIONPROPERTY(@pMAIN_2507200154055890290) AS SessionProperty_ANSI_NULLS,
SESSIONPROPERTY(@pMAIN_2507200154055890291) AS SessionProperty_ANSI_PADDING,
SESSIONPROPERTY(@pMAIN_2507200154055890292) AS SessionProperty_ANSI_WARNINGS,
SESSIONPROPERTY(@pMAIN_2507200154055890293) AS SessionProperty_ARITHABORT,
SESSIONPROPERTY(@pMAIN_2507200154055890294) AS SessionProperty_CONCAT_NULL_YIELDS_NULL,
CASE WHEN SESSIONPROPERTY(@pMAIN_2507200154055890295) IS NULL THEN @pMAIN_2507200154055890296 ELSE @pMAIN_2507200154055890297 END AS SessionProperty_NUMERIC_ROUNDABOUT,
SESSIONPROPERTY(@pMAIN_2507200154055890298) AS SessionProperty_QUOTED_IDENTIFIER;
Parameters (If used)
Name |
Value |
@pMAIN_2507200154055890290 |
ANSI_NULLS |
@pMAIN_2507200154055890291 |
ANSI_PADDING |
@pMAIN_2507200154055890292 |
ANSI_WARNINGS |
@pMAIN_2507200154055890293 |
ARITHABORT |
@pMAIN_2507200154055890294 |
CONCAT_NULL_YIELDS_NULL |
@pMAIN_2507200154055890295 |
NUMERIC_ROUNDABOUT |
@pMAIN_2507200154055890296 |
0 |
@pMAIN_2507200154055890297 |
1 |
@pMAIN_2507200154055890298 |
QUOTED_IDENTIFIER |
Query Results 1:
|
SessionProperty_ANSI_NULLS |
SessionProperty_ANSI_PADDING |
SessionProperty_ANSI_WARNINGS |
SessionProperty_ARITHABORT |
SessionPropertyCONCAT_NULL_YIELDS_NULL |
SessionProperty_NUMERIC_ROUNDABOUT |
SessionProperty_QUOTED_IDENTIFIER |
1 |
1
|
1
|
1
|
0
|
0
|
0
|
1
|