[execsp.bat]

SET PORT=1433

SET DBSERVER=localhost

SET INSTANCE=MSSQLSERVER

SET DBNAME=DB1

sqlcmd -S %DBSERVER%\%INSTANCE%,%PORT% -v InFiscalYear=2009 -i D:\execsp.sql

[execsp.sql]

sp1というストアドを実行する

EXEC DB1.sp1

'$(InFiscalYear)'