use test;
begin try
begin TRANSACTION
delete from city
-- SELECT 1/0;
COMMIT TRANSACTION;
end try
begin catch
ROLLBACK TRANSACTION;
SELECT ERROR_LINE() AS ErrorLine,ERROR_MESSAGE() AS ErrorMessage;
end catch
begin try
begin TRANSACTION
delete from city
-- SELECT 1/0;
COMMIT TRANSACTION;
end try
begin catch
ROLLBACK TRANSACTION;
SELECT ERROR_LINE() AS ErrorLine,ERROR_MESSAGE() AS ErrorMessage;
end catch