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_2507192040574596130) AS SessionProperty_ANSI_NULLS,
       SESSIONPROPERTY(@pMAIN_2507192040574596131) AS SessionProperty_ANSI_PADDING,
       SESSIONPROPERTY(@pMAIN_2507192040574596132) AS SessionProperty_ANSI_WARNINGS,
       SESSIONPROPERTY(@pMAIN_2507192040574596133) AS SessionProperty_ARITHABORT,
       SESSIONPROPERTY(@pMAIN_2507192040574596134) AS SessionProperty_CONCAT_NULL_YIELDS_NULL,
       CASE WHEN SESSIONPROPERTY(@pMAIN_2507192040574596135) IS NULL THEN @pMAIN_2507192040574596136 ELSE @pMAIN_2507192040574596137 END AS SessionProperty_NUMERIC_ROUNDABOUT,
       SESSIONPROPERTY(@pMAIN_2507192040574596138) AS SessionProperty_QUOTED_IDENTIFIER;


            
        

Parameters (If used)

Query Results 1: