SqlServer

1、SqlServer快速查找所有存储过程中是否包含某字符

select name 
from sysobjects o, syscomments s 
where o.id = s.id 
    and text like '%aaa%' 
    and o.xtype = 'P'

2、死锁处理 

//查询死锁
select    
    request_session_id spid,   
    OBJECT_NAME(resource_associated_entity_id) tableName    
from    
    sys.dm_tran_locks   
where    
    resource_type='OBJECT' 

//杀死死锁
kill 666

//显示死锁信息
exec sp_who2 354