CODEWITHSUNDEEP
sql-serverdatabase
sveerap
sveerap

Reputation: 841

Transactions in stored procedures

I have been asked an interesting question on implementing transactions in a stored procedure. And I don't have any idea on this. Suppose I have 10 statements in a stored procedure. I would like at least 5 to commit always even the rest of other fail and I have to do this within a single transaction. Any idea how to implement this?. Please advise

Upvotes: 0

Views: 89

Answers (1)

Pranay Rana
Pranay Rana

Reputation: 176896

check this : SAVE TRANSACTION (Transact-SQL) : http://msdn.microsoft.com/en-us/library/ms188378.aspx this will help you in how to achieve functionality

Upvotes: 1

Related Questions