SQLCMD mode in SSMS

SQLCMD mode in SSMS

Here are some commands very useful. Things help to deploy complicated queries.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
:CONNECT localhost
:setvar DBA "DBA"
:on error exit
GO
USE [$(DBA)]
go
SELECT DB_NAME()
print 'abc.sql -- Simon'
:r c:\temp\abc.sql
GO
print 'abcdef.sql -- Simon'
:r c:\temp\abcdef.sql
GO