Transaction use in storeprocedure

 begin transaction
--do here your sql work
        if (@@error = 0)
begin
commit Transaction
select 'Insert successfully'
end
 else
begin
 Rollback Transaction
 select 'Error in Insert'+CAST(@@error as varchar(88))
end