• SQL Server
• ::
• Transaction
• ::
• ตัวอย่างของ Explicit Transactions ( 2 )

subject:ตัวอย่างของ Explicit Transactions ( 2 )
example:BEING TRANSACTION
	
	DELETE person WHERE id = 101

	SAVE TRANSACTION point_1

	INSERT INTO person ( firstname, lastname, sex ) VALUES ( 'function', 'in.th', 1 )
	IF @@ERROR > 0
	BEGIN
		ROLLBACK TRANSACTION point_1
	END

	UPDATE person SET firstname = "Mr. " + firstname WHERE sex = 1
	IF @@ERROR > 0
	BEGIN
		ROLLBACK TRANSACTION 
	END

COMMIT TRANSACTION