SQL基础：SQL SERVER提交事务回滚机制

1、回滚语句1：

SET XACT_ABORT OFF

BEGIN TRAN

INSERT INTO score VALUES (101,90)
INSERT INTO score VALUES (102,78)
INSERT INTO score VALUES (107,76) /**//* Foreign Key Error */
INSERT INTO score VALUES (103,81)
INSERT INTO score VALUES (104,65)