Answer Posted / Pankaj Yadav
In SQL, COMMIT and ROLLBACK are database transaction management commands. COMMIT confirms the changes made during a transaction and saves them to the database permanently. ROLLBACK undoes all changes made during a transaction, effectively reverting the database back to its state before the transaction began.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why and when do stored procedure recompile?
How do I start sql server 2017?
How can you append an identity column to a temporary table?
When should you use an instead of trigger?
What is clustered index
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain “row_number()” in sql server with an example?
What is acid mean in sql server?
What is the difference between for xml raw and for xml auto?
What are the source of constraints?
What are the different SQL Server Versions you have worked on?
How to connect php with different port numbers?
Is it possible to have clustered index on separate drive from original table location?
How to convert numeric expression data types using the cast() function?
What is the primary use of the model database?
