Печать
Категория: MS SQL Server

begin try

begin tran tr_imp

select 1/0

commit tran tr_import_nn_artzvit

end try

begin catch

rollback tran tr_imp

select 'error'

--select @ErrNum = ERROR_NUMBER(), @ErrMsg = 'Ошибка! ' + CAST(ERROR_MESSAGE() as varchar(200))-- + 'строка ' + ERROR_LINE()

end catch