sql server 存储过程返回错误信息（编号：20110617A1020）

最新推荐文章于 2025-07-29 16:50:27 发布

原创最新推荐文章于 2025-07-29 16:50:27 发布 · 1.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #存储

本文介绍如何使用Transact-SQL中的RAISERROR函数引发错误，并通过TRY...CATCH结构捕获并处理这些错误。示例展示了如何在遇到特定严重级别错误时跳转到CATCH块，并在CATCH块中重新引发原始错误。

http://msdn.microsoft.com/en-us/library/ms178592.aspx

RAISERROR (Transact-SQL)

... BEGIN TRY -- RAISERROR with severity 11-19 will cause execution to -- jump to the CATCH block. RAISERROR ('Error raised in TRY block.', -- Message text. 16, -- Severity. 1 -- State. ); END TRY BEGIN CATCH DECLARE @ErrorMessage NVARCHAR(4000); DECLARE @ErrorSeverity INT; DECLARE @ErrorState INT; SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); -- Use RAISERROR inside the CATCH block to return error -- information about the original error that caused -- execution to jump to the CATCH block. RAISERROR (@ErrorMessage, -- Message text. @ErrorSeverity, -- Severity. @ErrorState -- State. ); END CATCH; ...