Posts sql transaction
Post
Cancel

sql transaction

STEP 1 :

1
2
3
4
5
6
7
8
9
10
11
12
	use mydbase

	begin tran

	select * from Product where Product_ID = 22236

	UPDATE product 
	SET    price1 = '685', 
		   price2 = '556.91' 
	WHERE  product_id = 22236 

	select * from Product where Product_ID = 22236

STEP 2 :

1
2
3
 #if we like what we see run commit otherwise rollback#
	--rollback
	--commit

#rollback #commit #tran

origin - http://www.pipiscrew.com/?p=2762 sql-sql-transaction

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags