mssql procedure try catch
BEGIN  BEGIN TRY         -- do someting  END TRY  BEGIN CATCH   --DB查詢用   SELECT ERROR_NUMBER() AS ErrorNumber,       ERROR_MESSAGE() AS ErrorMessage,       ERROR_LINE() AS ErrorLine,       ERROR_PROCEDURE() AS ErrorProcedure,       ERROR_SEVERITY() AS ErrorSeverity,       ERROR_STATE() AS ErrorState   --系統拋回訊息用   DECLARE @ErrorMessage As NVARCHAR(1000) = N'錯誤代碼:' +CAST(ERROR_NUMBER() AS VARCHAR) + ';'             +N'錯誤程序名稱:'+ ISNULL(ERROR_PROCEDURE(),'')+ ';'             +N'錯誤行號:'+ CAST(ERROR_LINE() AS VARCHAR)+ ';'             +N'錯誤訊息:'+ ERROR_MESSAGE()   DECLARE @ErrorSeverity As Numeric = ERROR_SEVERITY()   DECLARE @ErrorState As Numeric = ERROR_STATE()   RAISERROR( @ErrorMessage, @ErrorSeverity, @ErrorState);--回傳錯誤資訊  END CATCH END