我无法使用THROW SQL Server2008 R2
我无法使用THROW SQL Server2008 R2
提问于 2013-05-21 21:14:12
SQL Server2008SQL Management Studio无法识别我在下面的示例中抛出的异常，它说
抛出附近的语法不正确
我试图在这里抛出一个错误，这样当有人插入相同的值两次时，我就可以在我的网站中处理它。
Begin Try
insert into BusinessID (BusinessID) values (@ID)
insert into BusinessID (BusinessID) values (@ID)
End Try
Begin Catch
Print 'PK already exist'
THROW
End Catch回答 2
Stack Overflow用户
回答已采纳
发布于 2013-05-21 21:17:04
SQL Server 2012中引入了THROW语句
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;Stack Overflow用户
发布于 2013-05-21 21:20:54
使用RAISERROR而不是在sql块中抛出。
Begin Try
insert into BusinessID (BusinessID) values (@ID)
insert into BusinessID (BusinessID) values (@ID)
End Try
Begin Catch
Print 'PK already exist'
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页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/16670985
复制相关文章
相似问题