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

复制代码 代码如下: BEGIN TRY … … END TRY BEGIN CATCH DECLARE @ErrorMessage NVARCHAR(4000); DECLARE @ErrorSeverity INT; DECLARE @ErrorState INT; SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorSta

复制代码 代码如下: BEGIN TRY … … END TRY 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;

上一篇 win10系统如何安装usb驱动?win10安装usb驱动的方法
下一篇 MySQL索引提高查询效率的原因何在