CREATE TABLE ErrorLog(

 errNum INT,

 ErrSev NVARCHAR(1000),

 ErrState INT,

 ErrProc NVARCHAR(1000),

 ErrLine INT,

 ErrMsg NVARCHAR(2000)

 )

 CREATE PROCEDURE ProcErrorLog

 AS

 BEGIN

      SELECT

         ERROR_NUMBER() AS ErrNum,--返回导致运行 CATCH 块的错误消息的错误号。

         ERROR_SEVERITY()AS ErrSev,--返回导致 CATCH 块运行的错误消息的严重级别

         ERROR_STATE() AS ErrState,--返回导致 CATCH 块运行的错误消息的状态号

         ERROR_PROCEDURE() AS ErrProc,--返回出现错误的存储过程名称

         ERROR_LINE()AS ErrLine,--返回发生错误的行号

         ERROR_MESSAGE()AS ErrMsg--返回导致 CATCH 块运行的错误消息的完整文本

      INSERT INTO ErrorLog VALUES(

         ERROR_NUMBER(),

         ERROR_SEVERITY(),

         ERROR_STATE(),

         ERROR_PROCEDURE(),

         ERROR_LINE(),

     ERROR_MESSAGE())

 END

 CREATE PROCEDURE TestErrorLog

 AS

 BEGIN

     BEGIN TRY

         SELECT GETDATE()

         SELECT 1/0--Evergreen divide by zero example!

     END TRY

     BEGIN CATCH

         SELECT 'There was an error! ' + ERROR_MESSAGE()

         ProcErrorLog --调用上面的存储过程,保存错误日志

         RETURN

     END CATCH;

 END