CREATE TABLE myTable(id INT,content VARCHAR(MAX))

SET XACT_ABORT ONBEGIN TRY<core logic>END TRYBEGIN CATCH TRAN_ABORT<exception handling logic>END TRY@@error may be quired as first statement in CATCH block

USE demoGO--创建工作表CREATE TABLE student(stuid INT NOT NULL PRIMARY KEY,stuname VARCHAR(50))CREATE TABLE score(stuid INT NOT NULL REFERENCES student(stuid),score INT)GOINSERT INTO student VALUES (101,'zhangsan')INSERT INTO student VALUES (102,'wangwu')INSERT INTO student VALUES (103,'lishi')INSERT INTO student VALUES (104,'maliu')--调用一个运行时错误SET XACT_ABORT OFFBEGIN TRANINSERT INTO score VALUES (101,90)INSERT INTO score VALUES (102,78)INSERT INTO score VALUES (107, 76) /* 外键错误 */INSERT INTO score VALUES (103,81)INSERT INTO score VALUES (104,65)COMMIT TRANGOSELECT * FROM studentSELECT * FROM score--使用TRY...CATCH构造，并调用一个运行时错误SET XACT_ABORT OFFBEGIN TRYBEGIN TRANINSERT INTO score VALUES (101,90)INSERT INTO score VALUES (102,78)INSERT INTO score VALUES (107, 76) /* 外键错误 */INSERT INTO score VALUES (103,81)INSERT INTO score VALUES (104,65)COMMIT TRANPRINT '事务提交'END TRYBEGIN CATCHROLLBACKPRINT '事务回滚'SELECT ERROR_NUMBER() AS ErrorNumber,ERROR_SEVERITY() AS ErrorSeverity,ERROR_STATE() as ErrorState,ERROR_MESSAGE() as ErrorMessage;END CATCHGOSELECT * FROM scoreGO