begin
try
begin transaction
BEGIN
insert语句
insert 语句
update语句
select语句
commit transaction
END TRY
begin catch
set @msg = ' 失败说明 ' + char ( 13 ) + ' 行号: ' + cast (ERROR_LINE() as varchar ) + char ( 13 ) + ' 错误信息: ' + ERROR_MESSAGE()
ROLLBACK TRANSACTION
raiserror 99999 @msg
return ( - 1 )
end catch
return 0
begin transaction
BEGIN
insert语句
insert 语句
update语句
select语句
commit transaction
END TRY
begin catch
set @msg = ' 失败说明 ' + char ( 13 ) + ' 行号: ' + cast (ERROR_LINE() as varchar ) + char ( 13 ) + ' 错误信息: ' + ERROR_MESSAGE()
ROLLBACK TRANSACTION
raiserror 99999 @msg
return ( - 1 )
end catch
return 0