且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我无法使用 THROW SQL Server 2008 R2

更新时间:2023-02-03 11:06:20

THROW 语句是在SQL Server 2012

http://msdn.microsoft.com/en-us/library/ee677615.aspx一个>

您可以使用 RAISERROR 代替.

http://msdn.microsoft.com/en-us/library/483588bd-021b-4eae-b4ee-216268003e79(v=sql.105)

BEGIN CATCH
    DECLARE @ErrorMessage NVARCHAR(4000);
    DECLARE @ErrorSeverity INT;
    DECLARE @ErrorState INT;

    SELECT 
        @ErrorMessage = ERROR_MESSAGE(),
        @ErrorSeverity = ERROR_SEVERITY(),
        @ErrorState = ERROR_STATE();

    RAISERROR (@ErrorMessage, -- Message text.
               @ErrorSeverity, -- Severity.
               @ErrorState -- State.
               );
END CATCH;