Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Check current database name by using DB_NAME()

5> USE Northwind; 6> DECLARE @db AS NVARCHAR(258); 7> SET @db = QUOTENAME(N'pubs'); 8> EXEC(N'USE ' + @db + ';'); 9> SELECT DB_NAME(); 10> GO