SqlCmd in short

To enable SqlCmd in Management Studio, select:

Query / SQLCMD Mode

Management studio willl replace variables before these are sent to the Sql server

:setvar DbName DevDb

go

create procedure dbo.GetPersonsFromAnotherDb

as

select * from $(DbName).dbo.Person

print '$(DbName)'

go

/* Procedure will be created like:

ALTER procedure [dbo].[GetPersonsFromAnotherDb]

as

select * from DevDb.dbo.Person

print 'DevDb'

*/

To execute parameterized from sqlcmd.exe

file.sql containts the following:

print '$(DbName) was used as input'

Execute file:

sqlcmd -E -S . -i file.sql -v DbName=TstDb

Output:

TstDb was used as input