• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

Transactions in Sql Server stored procedures

I know we have in transactions the following  statements

BEGIN Transaction


Do we have an END TRANSACTION statement?
I don't think so but I just to make sure there isn't any such statement
2 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
>END TRANSACTION statement?  I
No ...
just commit and rollback
metro156Author Commented:
So you are saying the COMMIT or Rollback will always end the transaction???
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Yes.  COMMIT ends it by executing it, and ROLLBACK ends it by killing all actions between BEGIN and ROLLBACK.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now