sql 数据库 try --- catch用法

begin try
select 5/0
end try
begin catch
select
ERROR_NUMBER()     as     N'错误号',
ERROR_SEVERITY()     as     N'错误严重等级',
ERROR_STATE()     as     N'错误状态',
ERROR_PROCEDURE()    as     N'错误的过程名称',
ERROR_LINE()     as     N'产生错误的行号',
ERROR_MESSAGE()     as     N'错误消息文本'
end catch
go

 

转载于:https://www.cnblogs.com/yl1993/p/3843472.html