How to fire multiple sql statements as one transaction.

[Kumar]

Hey

I have few native sql queries(some inserts, some updates). I want to fire
all at once. I mean to say if success then everything should be success
else none. If one is failed then do i have a chance to rollback?

Thanks
Kumar