在回滚事务SQL之后 [英] THROW after Rollbacking transaction 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屋！