USE master
go
CREATE PROCEDURE sp_who_lock
AS
BEGIN
DECLARE @spid INT ,
@bl INT ,
@intTransactionCountOnEntry INT ,
@intRowcount INT ,
@intCountProperties INT ,
@intCounter INT
CREATE TABLE #tmp_lock_who
(
id INT IDENTITY( 1 , 1 ) ,
spid SMALLINT ,
bl SMALLINT
)
IF @@ERROR <> 0
RETURN @@ERROR
INSERT INTO #tmp_lock_who
( spid ,
bl
)
SELECT 0 ,
blocked
FROM ( SELECT *
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余3页未读,立即下载