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

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

S.Naveen...