sqlに引数を渡す方法

▼バッチやコマンドプロンプト（渡す側）

sqlcmd -U "user1" -P "xxxxx" -S "sv1\db1" -d "master" -b -v dbname=kintai -i c:\tools\killcon.sql 

▼SQL（受け取る側）

DECLARE @SPID AS SMALLINT

DECLARE Murderer CURSOR FOR
    SELECT spid FROM sys.sysprocesses WHERE DB_NAME(dbid) = $(dbname) -- ★引数を変数へ代入

OPEN Murderer

FETCH NEXT FROM Murderer INTO @SPID

DECLARE @SQL AS VARCHAR(128)

WHILE @@FETCH_STATUS = 0
    BEGIN
    SET @SQL = 'Kill ' + CAST(@SPID AS VARCHAR(10)) + ';'
    EXEC (@SQL)
    PRINT  ' Process ' + CAST(@SPID AS VARCHAR(10)) +' has been killed'
    FETCH NEXT FROM Murderer INTO @SPID
    END 

CLOSE Murderer
DEALLOCATE Murderer

SQL Serverのsqlcmdに引数を渡す - azuki note https://kenichiro22.hatenablog.com/entry/20110420/1303269189

【SQL Server】sqlcmdで実行するsqlファイルに引数を渡す方法 - 備忘録と https://workaholist.hatenablog.com/entry/20100218/1266490685