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