BEGIN
BEGIN TRY
-- 可能出错的逻辑
SELECT 1 / @param
END TRY
BEGIN CATCH
-- 输出错误信息
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_MESSAGE() AS ErrorMessage,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS ErrorState,
ERROR_LINE() AS ErrorLine,
ERROR_PROCEDURE() AS ErrorProcedure;
-- 或者用 RAISERROR / THROW 重新抛出
THROW;
END CATCH
END 评 论