Wednesday, March 28, 2012

its Uragnt

Hello

My Bos Ask ME to Read about somthing called not Commited

i read but i not understand any thig

plz i need some one to Explain to me with Example

He may be talking about transactions and the ability to rollback not commited changes.


Very simple example is changing data in a table

-- start of transaction
BEGIN TRAN

-- update table
UPDATE tbl1

SET col1 = 5

-- status of transaction is not commited and data is not yet saved

-- option 1

COMMIT TRAN

-- transaction is now commited and the change is saved

-- option 2

ROLLBACK TRAN

-- transaction is rolled back and the change is not saved.

Hope this makes sense.

No comments:

Post a Comment