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