THROW （会中断事务）

最新推荐文章于 2025-04-16 15:26:15 发布

原创最新推荐文章于 2025-04-16 15:26:15 发布 · 879 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了在SQL中使用THROW和RAISERROR进行错误处理的区别。THROW能够终止当前批处理并提供更精确的错误控制，而RAISERROR则通常不能终止批处理。此外，文章还展示了如何使用FORMATMESSAGE()来格式化错误消息。

复制代码
-- You can issue a simple THROW as follows:
THROW 50000, 'Error in usp_InsertCategories stored procedure', 0;

-- Because THROW does not allow formatting of the message parameter, you can use FORMATMESSAGE()
GO
DECLARE @message AS NVARCHAR(1000) = N'Error in % stored procedure';
SELECT @message = FORMATMESSAGE (@message, N'usp_InsertCategories');
THROW 50000, @message, 0;
复制代码

复制代码
-- RAISERROR does not normally terminate a batch:
RAISERROR ('Hi there', 16, 0);
PRINT 'RAISERROR error'; -- Prints
GO

-- However, THROW does terminate the batch:
THROW 50000, 'Hi there', 0;
PRINT 'THROW error'; -- Does not print
GO