liyonghui123的专栏

  --每秒死锁数量SELECT  *FROM    sys.dm_os_performance_countersWHERE   counter_name LIKE 'Number of Deadlocksc%';--查询当前阻塞WITH    CTE_SID ( BSID, SID, sql_handle )          AS ( SELECT   blocking_session_i...

  Sqlserver返回结果集的存储过程调用方式：   一、存储过程：   create procedure selectCount @num int =0 as begin SELECT COUNT(0) FROM mytable end create procedure selectId @num int =0 as begin SEL...