Transaction- BEGIN, COMMIT,ROLLBACK

Begin Trans t
// Do processing

if @@Error<>0
Rollback Tran t
else
Commit Tran t