SET XACT_ABORT ON

BEGIN TRY
BEGIN TRAN
INSERT INTO pubs..jobs 
	VALUES('adverts1', 10, 20)
INSERT INTO pubs..jobs 
	VALUES('adverts2', 3, 20)
COMMIT TRAN
END TRY
BEGIN CATCH
IF XACT_STATE() = -1 ROLLBACK TRAN
ELSE COMMIT TRAN
END CATCH
a
b
c
