What is COMMIT and ROLLBACK statement in SQL

Posted By :Prasanti Prusty Posted Date :December 20, 2009 Points :10 Category :Sql Server

Commit statement helps in termination of the current transaction and do all the changes that occur in transaction persistent and this also commits all the changes to the database.
ROLLBACK do the same thing just terminate the currenct transaction but one another thing is that the changes made to database are ROLLBACK to the database.

You can also find related Interview Question to What is COMMIT and ROLLBACK statement in SQL below:

How many Columns per INSERT statement is allowed

4096 Columns allowed in per Insert SQL (More...)

Can multiple catch blocks be executed for a single try statement?

No. Once the proper catch block processed, control is transferred to the finally block (if any).

So we can not execute multiple catch block in one try block (More...)

The maximum number of column per SELECT Statement?

4096 (More...)

What is the equivalent statement for exit in C#?

Application.Exit() or System.Environment.Exit (More...)

What is the difference between UNION ALL Statement and UNION

The main difference between UNION ALL statement and UNION is UNION All statement is much faster than UNION.
Reason : Because UNION ALL statement does not look for duplicate rows, but on the other hand UNION statement does look for duplicate rows, whether or not they exist. (More...)

There is a DELETE statement inside a transaction. What happens if the transaction is rolled back?

Truncation statement cannot be rolled back (More...)

What is the purpose of @@LANGUAGE statement?

To know the current language used. (More...)

What is the purpose of @@FETCH_STATUS statement in T-SQL?

To know the status of the last cursor FETCH statement issued against any cursor currently opened by the connection (More...)

What is the use of @@CPU_BUSY statement?

@@CPU_BUSY returns the time that SQL Server has spent working since it was last started. (More...)

What is the use of @@CONNECTIONS statement?

@@CONNECTIONS returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started. (More...)

What is a COMPUTE BY statement?

COMPUTE BY statement has both detail and summary rows within the SELECT statement. It calculates the summary values for subgroups, or a summary value for the entire result set. (More...)

What is Modulo EQUALS statement in SQL server?

Modulo divides one number by another and return the result of the operation.
%= is the operator used for this. (More...)

What is the use of @@VERSION statement?

@@VERSION statement returns version, processor architecture, build date, and operating system for the current installation of SQL Server. (More...)

What is a Multi-statement Table-Value User-Defined Function?

A Multi-Statement Table-Value user-defined function returns a table and is also an exceptional alternative to a view as the function can support multiple T-SQL statements to build the final result where the view is limited to a single SELECT statement (More...)

Quick Links For Interview Questions Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	OOPs	JQuery	JavaScript/VBScript
Biztalk	Patten/Practices	.IIS	WCF	WPF	WWF
Networking	Aptitude	Others	All

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.