SQL Server kill 被阻塞会话 结束进程 死锁

--kill 被阻塞会话
select  'kill '+cast(spid as varchar) FROM sys.sysprocesses sp
where sp.blocked != and sp.spid != sp.blocked 
--and loginame='管理员账户或其他账户';