Solved

Transactions in Sql Server stored procedures

Posted on 2014-10-15
3
145 Views
Last Modified: 2014-10-15
I know we have in transactions the following  statements

BEGIN Transaction

COMMIT
ROLLBACK

Do we have an END TRANSACTION statement?
I don't think so but I just to make sure there isn't any such statement
0
Comment
Question by:metro156
3 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 40383254
>END TRANSACTION statement?  I
No ...
just commit and rollback
0
 

Author Comment

by:metro156
ID: 40383267
So you are saying the COMMIT or Rollback will always end the transaction???
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 40383501
Yes.  COMMIT ends it by executing it, and ROLLBACK ends it by killing all actions between BEGIN and ROLLBACK.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now