编程笔记

摘要： 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 阅读全文