transaction in sp mssql

transaction in sp mssql.sql

create procedure uspContactPersonDeleteSingleItem
@id int
as
begin tran
	delete from address where contactpersonid = @id;
	if @@ERROR <> 0 
	begin
		rollback tran
		return -1
	end
	delete from emailaddress where contactpersonid = @id;
	if @@ERROR <> 0
	begin
		rollback tran
		return -1
	end
	delete from phonenumber where contactpersonid = @id ;
	if @@ERROR <> 0
	begin
		rollback tran
		return -1
	end
	delete from contactperson where id = @id ;
	if @@ERROR <> 0
	begin
		rollback tran
		return -1
	end
commit tran
go