How to write sp with multiple inserts and work like commit rollback CONCEPT ?

Posted by Nav234 under Sql Server on 7/20/2010 | Views : 1837 | Status : [Member] | Replies : 1
Hi all ,
First Send me any proper URL or website for learning SP and writing SP.

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.

Thanks in advance



Posted by: Vuyiswamb on: 7/20/2010 [Member] [MVP] [Administrator] NotApplicable

Login to post response