CREATE proc proc_1

@tit1 varchar(10),

@tit2 varchar(10)

as

set nocount on

begin tran

delete from tab where title=@tit1

delete from tab where title=@tit2

IF @@ERROR <> 0

begin

rollback tran

print 'error'

return

end

ELSE

begin

commit tran

print 'ok'

end

GO