Metadata OBJECT_ID SQL function

1. Usage of OBJECT_ID

SQL Server Query 1

            
 SELECT OBJECT_ID('Northwind..customers')  

 UNION ALL  

 SELECT OBJECT_ID('Northwind.dbo.customers');  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new OBJECT_ID("Northwind..customers"), "Database_ID")  

     .UnionAll(new SqlQueryBuilder()  

         .Select().Column(new OBJECT_ID("Northwind.dbo.customers"), "Database_ID")  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OBJECT_ID(@pMAIN_2602032111134656410) AS Database_ID
UNION ALL
SELECT OBJECT_ID(@pMAIN_2602032111134656411) AS Database_ID;


            
        

Parameters (If used)

Query Results 1: