Transact SQL MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Transact SQL
  4. 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