执行,SQL出现死锁,,,要很长时间才能恢复,期间任何请求报“超时时间已到。在操作完成之前超时时间已过或服务器未响应。”CREATE PROCEDURE wx_DeleteEmail
@EmailID int,
@UserID int,
@ReturnId bit OUTPUT
AS
declare @CountNum int
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRANSACTION
--判断权限
if EXISTS(SELECT 1 FROM EmailConnectTable where EmailID=@EmailID and UserID=@UserID)
begin
--是否多人占有
SELECT @CountNum=count(1) FROM EmailConnectTable where EmailID=@EmailID
if @CountNum>1
begin
delete from EmailConnectTable where EmailID=@EmailID and UserID=@UserID
end
else
begin
delete from EmailConnectTable where EmailID=@EmailID and UserID=@UserID
delete from EmailFileList where ParentID=@EmailID
delete from EmailMain where id=@EmailID
end
return 1
end
else
return 0
COMMIT TRANSACTION
RETURN 0
GO
@EmailID int,
@UserID int,
@ReturnId bit OUTPUT
AS
declare @CountNum int
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRANSACTION
--判断权限
if EXISTS(SELECT 1 FROM EmailConnectTable where EmailID=@EmailID and UserID=@UserID)
begin
--是否多人占有
SELECT @CountNum=count(1) FROM EmailConnectTable where EmailID=@EmailID
if @CountNum>1
begin
delete from EmailConnectTable where EmailID=@EmailID and UserID=@UserID
end
else
begin
delete from EmailConnectTable where EmailID=@EmailID and UserID=@UserID
delete from EmailFileList where ParentID=@EmailID
delete from EmailMain where id=@EmailID
end
return 1
end
else
return 0
COMMIT TRANSACTION
RETURN 0
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货