如何在 SQL Server 的存储过程和函数里进行错误处理（try catch）

SQL Server 2005里引进了try...catch结构，下面具体讲述如何使用，并介绍处理错误是用到的各种函数和变量，包括：ERROR_NUMBER(),ERROR_SAEVERITY(),ERROR_STATE(),ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(),@@ERROR和RAISERROR

 

 

try...catch例子如下：

 

BEGIN TRY

    -- Generate a divide-by-zero error.

    SELECT 1/0;

END TRY

BEGIN CATCH

    SELECT

        ERROR_NUMBER() AS ErrorNumber,

        ERROR_SEVERITY() AS ErrorSeverity,

        ERROR_STATE() AS ErrorState,

        ERROR_PROCEDURE() AS ErrorProcedure,

        ERROR_LINE() AS ErrorLine,

        ERROR_MESSAGE() AS ErrorMessage;