34,593
社区成员
发帖
与我相关
我的任务
分享
存储过程简写,结构如下
create proc p_xxxx
as
--开始事务
begin tran
--执行插入语句1
--事务
SELECT @err = @@ERROR
if @err<>0
begin
rollback tran
--记录下错误日志
insert t_auto_cwf(rq,zxbz,nr,bz)
values(@rq,@err,'执行插入语句1失败',@zyls)
return
end
--执行插入语句2
--事务
SELECT @err = @@ERROR
if @err<>0
begin
rollback tran
--记录下错误日志
insert t_auto_cwf(rq,zxbz,nr,bz)
values(@rq,@err,'执行插入语句2失败',@zyls)
return
end
commit tran
BEGIN TRY
SELECT 1/0 --This will raise a divide by zero error if not handled
END TRY
BEGIN CATCH
SELECT ERROR_LINE() AS 'Line',
ERROR_MESSAGE() AS 'Message',
ERROR_NUMBER() AS 'Number',
ERROR_PROCEDURE() AS 'Procedure',
ERROR_SEVERITY() AS 'Severity',
ERROR_STATE() AS 'State'
END CATCH;