这样试试SET XACT_ABORT ON
go
BEGIN TRANSACTION
INSERT AA VALUES ('32',12,12,'12')
INSERT AA VALUES ('32','1A2',12,'12')
COMMIT TRANSACTION
go
BEGIN TRANSACTION
INSERT AA VALUES ('32',12,12,'12')
INSERT AA VALUES ('32','1A2',12,'12')
COMMIT TRANSACTION
BEGIN TRANSACTION
INSERT AA VALUES ('32',12,12,'12')
INSERT AA VALUES ('32','1A2',12,'12')
IF @@ERROR <> 0 goto TheError
COMMIT TRANSACTION
return TheError:
rollback transaction
INSERT AA VALUES ('32',12,12,'12')
IF @@ERROR <> 0 goto TheError
INSERT AA VALUES ('32','1A2',12,'12')
IF @@ERROR <> 0 goto TheError
COMMIT TRANSACTION
return TheError:
rollback transaction
INSERT AA VALUES ('32',12,12,'12')
IF @@ERROR <> 0 goto TheError
INSERT AA VALUES ('32','1A2',12,'12')
IF @@ERROR <> 0 goto TheError
COMMIT TRANSACTION
return TheError:
rollback transaction