查询死锁语句

select 0,spid,'kill ' + convert(varchar,spid) AS killcommand,'dbcc inputbuffer(' + CONVERT(VARCHAR,spid) +')' ,
a.status,lastwaittype,a1.client_net_address,a2.host_name,a2.program_name
,c.text
from sys.sysprocesses a
join sys.dm_exec_connections a1 on a.spid = a1.session_id
join sys.dm_exec_sessions a2 on a1.session_id = a2.session_id
cross apply sys.dm_exec_sql_text(a.sql_handle) c 
where blocked = 0 
and exists(select spid from sys.sysprocesses d where d.blocked = a.spid and d.spid <>a.spid)