Metadata STATS_DATE SQL function

1. Usage of STATS_DATE for customer table

SQL Server Query 1

            
 SELECT name AS Stats_Name,  

     STATS_DATE(object_id, Stats_Id) AS Statistics_Update_Date  

 FROM sys.stats  

 WHERE object_id = OBJECT_ID('customers');  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column("name", "Name")  

     .Column(new STATS_DATE(new Column("object_id"), new Column("Stats_ID")), "Statistics_Update_Date")  

     .From("sys.stats")  

     .Where(new Where(new Column("object_id").Equale(new OBJECT_ID("customers"))))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT name AS Stats_Name,
       STATS_DATE(object_id, Stats_ID) AS Statistics_Update_Date
FROM sys.stats
WHERE object_id = OBJECT_ID(@pMAIN_2507192019002929660);


            
        

Parameters (If used)

Query Results 1:

2. Usage of STATS_DATE for employee table

SQL Server Query 2

            
 SELECT name AS Index_Name,  

     STATS_DATE(object_id, index_id) AS Statistics_Update_Date  

 FROM sys.indexes  

 WHERE object_id = OBJECT_ID('employees');  

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select()  

     .Column("name", "Index_Name")  

     .Column(new STATS_DATE(new Column("object_id"), new Column("index_id")), "Statistics_Update_Date")  

     .From("sys.indexes")  

     .Where(new Where(new Column("object_id").Equale(new OBJECT_ID("employees"))))  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT name AS Index_Name,
       STATS_DATE(object_id, index_id) AS Statistics_Update_Date
FROM sys.indexes
WHERE object_id = OBJECT_ID(@pMAIN_2507192019004987960);


            
        

Parameters (If used)

Query Results 2:

3. Usage of STATS_DATE for products table

SQL Server Query 3

            
 SELECT Stats_Id, name AS Stats_Name,  

     STATS_DATE(object_id, Stats_Id) AS Statistics_Update_Date  

 FROM sys.stats  

 WHERE object_id = OBJECT_ID('products');  

            
        

Create SQL query with SqlQueryBuilder 3

            
 var (sql3, parameters3) = new SqlQueryBuilder()  

     .Select()  

     .Column("Stats_Id", "Stats_Id")  

     .Column("name", "Stats_Name")  

     .Column(new STATS_DATE(new Column("object_id"), new Column("Stats_Id")), "Statistics_Update_Date")  

     .From("sys.stats")  

     .Where(new Where(new Column("object_id").Equale(new OBJECT_ID("employees"))))  

     .Build();  

            
        

Query build by SqlQueryBuilder 3

            
SELECT Stats_Id AS Stats_Id,
       name AS Stats_Name,
       STATS_DATE(object_id, Stats_Id) AS Statistics_Update_Date
FROM sys.stats
WHERE object_id = OBJECT_ID(@pMAIN_2507192019005089150);


            
        

Parameters (If used)

Query Results 3:

4. Usage of STATS_DATE for region table

SQL Server Query 4

            
 SELECT name AS Index_Name,  

     STATS_DATE(object_id, Stats_Id) AS Statistics_Update_Date  

 FROM sys.indexes  

 WHERE object_id = OBJECT_ID('region');  

            
        

Create SQL query with SqlQueryBuilder 4

            
 var (sql4, parameters4) = new SqlQueryBuilder()  

     .Select()  

     .Column("name", "Index_Name")  

     .Column(new STATS_DATE(new Column("object_id"), new Column("index_id")), "Statistics_Update_Date")  

     .From("sys.indexes")  

     .Where(new Where(new Column("object_id").Equale(new OBJECT_ID("region"))))  

     .Build();  

            
        

Query build by SqlQueryBuilder 4

            
SELECT name AS Index_Name,
       STATS_DATE(object_id, index_id) AS Statistics_Update_Date
FROM sys.indexes
WHERE object_id = OBJECT_ID(@pMAIN_2507192019005177630);


            
        

Parameters (If used)

Query Results 4: