kill 命令如何用？

[turbochen]

USE master

DECLARE smis_cursor CURSOR FOR
SELECT spid FROM sysprocesses
WHERE dbid=15 and status='sleeping'

OPEN smis_cursor

DECLARE @k_spid smallint
FETCH NEXT FROM smis_cursor
INTO @k_spid

WHILE @@FETCH_STATUS = 0
BEGIN
kill @k_spid
FETCH NEXT FROM smis_cursor
INTO @k_spid
END

CLOSE smis_cursor
DEALLOCATE smis_cursor
GO

以上代码我想杀掉某些sleeping的进程，但sql server报告说在“kill @k_spid”有语法错误。但我将它变量改成一个固定的常量如“kill 55”，就没语法问题。难道kill命令的参数只能是常量吗？