Metadata DB_NAME SQL function

1. Usage of DB_NAME

SQL Server Query 1

            
 SELECT DB_NAME() AS Current_Database  

 union  

 SELECT DB_NAME(3) AS Current_Database  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new DB_NAME(), "Current_Database")  

     .Union(new SqlQueryBuilder()  

         .Select()  

         .Column(new DB_NAME(3), "Current_database")  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT DB_NAME() AS Current_Database
UNION
SELECT DB_NAME(@pMAIN_2603220459261129000) AS Current_database;


            
        

Parameters (If used)

Query Results 1:

1. Usage of DB_NAME with sys table

SQL Server Query 2

            
 SELECT DB_NAME(database_id) AS [Database],  

  Database_ID  

 FROM sys.databases;  

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select()  

     .Column(new DB_NAME(new Column("database_id")), "[Database]")  

     .Column("Database_ID", "Database_ID")  

     .From("sys.databases")  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT DB_NAME(database_id) AS [Database],
       Database_ID AS Database_ID
FROM sys.databases;


            
        

Parameters (If used)

Query Results 2: