Metadata DB_ID SQL function

1. Usage of DB_ID

SQL Server Query 1

            
 SELECT DB_ID() AS Database_ID  

 UNION ALL  

 SELECT DB_ID('Northwind') AS Database_ID

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new DB_ID(), "Database_ID")  

     .Union(new SqlQueryBuilder()  

         .Select()  

         .Column(new DB_ID("Northwind"), "Database_ID")  

     )  

     .Build();

Query build by SqlQueryBuilder 1

            
SELECT DB_ID() AS Database_ID
UNION ALL
SELECT DB_ID(@pMAIN_2507200128177136380) AS Database_ID;

Parameters (If used)

Name	Value
@pMAIN_2507200128177136380	Northwind

Query Results 1:

	Database_ID
1	43
2	0