存储过程里为什么不执行两条操作啊？？

[chen2319]

CREATE PROCEDURE [dbo].[Proc_ScoreDelete]
(@ID [int],
@UserID nvarchar(50),
@PaperID [int])
AS
BEGIN
DELETE [OnLineExam].[dbo].[Score] WHERE ( [ID] = @ID)
UPDATE [OnLineExam].[dbo].[UserAnswer] SET [UserMark] = NULL
WHERE [PaperID] = @PaperID AND [UserID] = @UserID AND [Type] in ('填空题','问答题')
END
GO
----------------------------------
exec Proc_ScoreDelete 43,102,080010只是执行了DELETE ？这是为什么啊？

[-狙击手-]

删除的是不是正好是你要更新的记录 呀

[dawugui]

不会吧.

[dawugui]

语句没看出错误来,检查下逻辑吧.

[dawugui]

--换个位置试试?

CREATE PROCEDURE [dbo].[Proc_ScoreDelete] 
(@ID [int], 
@UserID nvarchar(50), 
@PaperID [int]) 
AS 
BEGIN 
UPDATE [OnLineExam].[dbo].[UserAnswer] SET [UserMark] = NULL 
WHERE [PaperID] = @PaperID AND [UserID] = @UserID AND [Type] in ('填空题','问答题') 

DELETE [OnLineExam].[dbo].[Score]  WHERE  ( [ID] = @ID) 
END 
GO 

[Yang_]

select * from [OnLineExam].[dbo].[UserAnswer] 
where [Type] in ('填空题','问答题') 

是不是没记录返回？

[chen2319]

[Quote=引用 1 楼 happyflystone 的回复:]
删除的是不是正好是你要更新的记录 呀
[/Quote]

BEGIN 
DELETE [OnLineExam].[dbo].[Score]  WHERE  ( [ID] = @ID) 
UPDATE [OnLineExam].[dbo].[UserAnswer] SET [UserMark] = NULL 
WHERE [PaperID] = @PaperID AND [UserID] = @UserID AND [Type] in ('填空题','问答题') 
END 

在查询分析器中执行以上的语句，DELETE 和UPDATE 都执行了啊。

[chen2319]

[Quote=引用 5 楼 Yang_ 的回复:]
SQL codeselect * from [OnLineExam].[dbo].[UserAnswer]
where [Type] in ('填空题','问答题')


是不是没记录返回？
[/Quote]有记录