create proc adds
as
begin
declare @tran varchar(50)
begin tran @tran
insert into titles(title_id,title) values('111','222')
rollback tran @tran
end
go
as
begin
declare @tran varchar(50)
begin tran @tran
insert into titles(title_id,title) values('111','222')
rollback tran @tran
end
go