Mega Code Archive

 

Categories / MSSQL Tutorial / Transact SQL

 

Switch database in EXEC

4> SET NOCOUNT ON 5> PRINT db_name() 6> EXEC ('USE Northwind PRINT db_name() SELECT count(*) FROM products') 7> PRINT db_name() 8> GO master