LISTING 1: Code That Dynamically Builds a Kill Statement

DECLARE @command varchar(50),
        @spid smallint

SELECT @spid=12
SELECT @command='kill '+ CONVERT(varchar(3),@spid)
EXECUTE @command