SqlServer 事务的启用

BEGIN

	SET XACT_ABORT ON;

	BEGIN TRANSACTION
  	UPDATE dbo.Person SET Age = 111 WHERE Id = 4;
  	UPDATE dbo.Person SET Age = 111 WHERE Id = 9;
  	DECLARE @a int, @b INT
        SET @a = 10
  	SET @b = @a / 0
  	PRINT @b
  	UPDATE dbo.Person SET Age = 111 WHERE Id = 10;
	IF @@ERROR = 0
  	COMMIT TRANSACTION;
	ELSE
  	ROLLBACK TRANSACTION;
  
	SET XACT_ABORT OFF;

END;