摘要: CREATEprocedure [dbo].[sp_who_lock]asbegindeclare @spid int,@bl int,@intTransactionCountOnEntryint,@intRowcountint,@intCountPropertiesint,@intCounterintcreate table #tmp_lock_who (id int identity(1,1),spid smallint,bl smallint)IF @@ERROR0 RETURN @@ERRORinsert into #tmp_lock_who(spid,bl) select0 ,blo 阅读全文
posted @ 2013-07-12 17:41 编程笔记 阅读(813) 评论(0) 推荐(0) 编辑