如何编写具有多个插入的sp并像提交回滚CONCEPT一样工作?
问题描述：
大家好，
像提交回滚"一样，我应该编写一个SP来执行多个插入.
注意:我应该检查所有这些多重插入是否成功或
否则应该回滚.
向我建议任何不错的网站来学习sp并编写sp
在此先感谢
Naveen ...:rolleyes:
Hi all ,
Like Commit Roll back ,I should write an SP to execute multiple inserts.
NOTE : I should check whether all those mutiple inserts were successfull or
else it should rol back.
Suggest me any nice website to learn sp and writing sp
Thanks in advance
Naveen... :rolleyes:
答
您在这里:
存储过程 [ TRY ... CATCH(Transact-SQL) [开始交易(Transact-SQL) [
Here you go:
Stored Procedures[^]
TRY...CATCH (Transact-SQL)[^]
BEGIN TRANSACTION (Transact-SQL)[^]
You need to learn on Try-Catch first. Then Learn on Transaction. And then abot Stored Procedure.
Steps:
1. Use Try Catch
2. Implement Transactions in Try Catch
3. Use Stored Procedure in Transaction.
您好，Sandeep
谢谢您的回应
但是您发布的答案对我来说似乎更高.
我已经在vb.net和c#中学习了TRY CATCH.但是
我想知道，如何编写SP，
存储过程对多个insert语句执行
并像Commit Roll Back Concept一样工作.
希望你理解我的问题
希望很快能收到您的回音
在此先感谢
Naveen ...:confused:
Hi Sandeep
Thank you for your response
But the answer u posted is like quite higher for me.
I have learnt TRY CATCH in vb.net and c # .But
I want to know ,how to write SP,
Stored Procedure to multiple insert statements execute
and work like Commit Roll Back Concept .
Hope you understand my problem
and hope to hear from you soon
Thanks in advance
Naveen...:confused: