Pradeep
What does COMMIT do ?
By Pradeep in Databases & DBA on Sep 14 2009
  • Asad Butt
    Sep, 2009 14

    Commit basically refers to an action which makes all the changes permanant since the last commit.
    commit is alos availabale for non-Sql transanctions, like a method  available with Installer class which finalises
    installation after all installation steps have been carried out successfully

    public override void Commit(System.Collections.IDictionary savedState)
    {
        base.Commit(savedState);
    }

    so commit simplly is a mechanism to finalise what you have done and make changes permanant

    • 0
  • Sapna Malik
    Sep, 2009 14

    COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed. 

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS