在SQL Server的try...catch语句中获取错误消息代码的的语句

复制代码 代码如下:

BEGIN TRY
...
...
END TRY
BEGIN CATCH
DECLARE @ErrorMessage NVARCH gzYVYY AR(4000); www.cppcns.com
DECLARE @ErrorSeverit javascript y INT;
DECLARE @ErrorState INT;

S js ELECT
@ErrorMessage = ERROR_MESSAGE(),
@ErrorSeverity = ERROR_SEVERITY(),
@ErrorState = ERROR_STATE();

RAISERROR (@ErrorMessage, -- Message text.
@ErrorSeverity, -- Severity.
@Err www.cppcns.com orState -- State.
);
END CATCH;

查看更多关于在SQL Server的try...catch语句中获取错误消息代码的的语句的详细内容...