在回滚事务SQL之后 [英] THROW after Rollbacking transaction SQL
本文介绍了在回滚事务SQL之后的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好我有一个存储过程,我根据要求去了Transaction,这是我的SP
Hi all I have a stored procedure where I have gone for Transaction as per the requirement, this is my SP
CREATE PROCEDURE ProcName
@Id INT,
@user_id INT
AS
BEGIN
BEGIN TRANSACTION [transName]
BEGIN TRY
DELETE
FROM table1
WHERE UserId= @user_id
UPDATE table2
SET DATE_MODIFIED = GETDATE()
WHERE ID= @Id
COMMIT TRANSACTION [transName]
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION [transName]
THROW
END CATCH
END
我在THROW附近收到错误语法等异常一些人告诉我哪里出错
I am getting an exeception like incorrect syntax near THROW can some tell where I am going wrong
推荐答案
MSDN文档是一个很好的起点,可以阅读如何使用 THROW
(您必须提供错误参数): http://msdn.microsoft.com/en-us /李brary / ee677615.aspx [ ^ ]
MSDN documentation is a good place to start and read about how to use THROW
(you have to supply error parameters): http://msdn.microsoft.com/en-us/library/ee677615.aspx[^]
这解决了我的问题
https://www.simple-talk.com/sql/database-administration/handling-errors-in-sql-server-2012 / [ ^ ]
This solved my issue
https://www.simple-talk.com/sql/database-administration/handling-errors-in-sql-server-2012/[^]
这篇关于在回滚事务SQL之后的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文