How to make trasanction cover multiple stored procedures?

Question

I need to include several stored procedures in one transaction in the same database, if any of the stored procedures failed, the transaction is rolled back to the entire stored procedure processed in the area.

I am working with SQL-SERVER 2008

Answer 1

begin transaction
begin try
  exec proc_1
  exec proc_2
  exec proc_3
  commit transaction
end try
begin catch
  rollback transaction
end catch

Answer 2

, , . - , . , (MS SQL Server, MySQL ..), .

Answer 3

, , api, " ".

.Net example http://msdn.microsoft.com/en-us/library/2k2hy99x.aspx ado.net

Answer 4

, .

SQL Server