Buy Questpond's video subscriptions on
huge discount
.
Online: 1825
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
How Can we Write the Transaction Block in SQL Server?
Posted by
Lakhangarg
on 8/25/2009 | Category:
Sql Server Interview questions
| Views: 8676
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
BEGIN TRANSACTION
Statement 1
Statement 2
..................
...............
IF(@ERROR>0)
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
Difference Between Truncate Table and Delete Table ...
Next > :
How can we Rollback the Transaction in DataBase?
Comments or Responses
Login to post response
More Interview Questions by Lakhangarg
How can we Rollback the Transaction in DataBase?
Who Developed JavaScript?
Will COUNT(column) include columns with null values in its count?
What is the page size in SQL Server?
Can UNIQUE KEY in SQL Server 2005 have two or more NULL?
What’s the difference between a primary key and a unique key?
The maximum number of columns a table can have in SQL Server?
Should we need to dispose the object after use Explicitly or we need t ...
Latest Interview Questions
Which method is used to commit all changes in the DataSet or DataTable ...
Which method is used to create a new row in a Table
How to disable the page viewstate by
disadvantages of hidden fields?
What does is Nan function do?
What Boolean operators are not supported by JavaScript?
Difference between ASP.Net Website and ASP.Net Web Application?
Difference between Localization and Globalization?
More ...