Multitable insert - transaction support

Hi ,
Is it possible to insert records in multipletables in s single transaction as if we insert to a database like :
begin transaction
insert into customer
insert into sales
commit
thanks
tolga