Other MONTH SQL function

1. Usage of MONTH to analysis order's month in number and name

SQL Server Query 1

            
 SELECT  

     OrderID,  

     OrderDate,  

     MONTH(OrderDate) AS MonthNumber,  

     DATENAME(MONTH, OrderDate) AS MonthName,  

     ShippedDate,  

     MONTH(ShippedDate) AS ShipMonthNumber,  

     DATENAME(MONTH, ShippedDate) AS ShipMonthName  

 FROM Orders  

 WHERE OrderID IN (10248, 10249, 10250, 10251, 10252);  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column("OrderID", "OrderID")  

     .Column("OrderDate", "OrderDate")  

     .Column(new MONTH(new Column("OrderDate")), "MonthNumber")  

     .Column(new DATENAME(SqlDateInterval.month, new Column("OrderDate")), "MonthName")  

     .Column("ShippedDate", "ShippedDate")  

     .Column(new MONTH(new Column("ShippedDate")), "ShipMonthNumber")  

     .Column(new DATENAME(SqlDateInterval.month, new Column("ShippedDate")), "ShipMonthName")  

     .From("Orders")  

     .Where(new Where(new IN(new Column("OrderID"), 10248, 10249, 10250, 10251, 10252)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OrderID AS OrderID,
       OrderDate AS OrderDate,
       MONTH(OrderDate) AS MonthNumber,
       DATENAME(month, OrderDate) AS MonthName,
       ShippedDate AS ShippedDate,
       MONTH(ShippedDate) AS ShipMonthNumber,
       DATENAME(month, ShippedDate) AS ShipMonthName
FROM Orders
WHERE OrderID IN (@pMAIN_2609201710337087720, @pMAIN_2609201710337087721, @pMAIN_2609201710337087722, @pMAIN_2609201710337087723, @pMAIN_2609201710337087724);


            
        

Parameters (If used)

Query Results 1: