quote:

---

Originally posted by sent_sara

below code is working fine,while passing query correctly
if i pass the value like this:
exec proctest('rab44','sent','25','fff')
this gets rollbacked correctly..Just i need to know where the error occured whether in first begin,end statment or the second one and then the type of error occured

create procedure proctest(@idno char(7),@name varchar(9),@age int,@wages decimal(15,2))
as
declare @err int
set nocount on

begin transaction
begin
insert into gworker(idno,name) values(@idno,@name)
set @err=@@error
if @err<>0
rollback tran
end

begin
insert into oworker(idno,age) values(@idno,@age)
@err=@@error
if @err<>0
rollback tran
end

begin
insert into msalary(idno,wages) values(@idno,@wages)
@err=@@error
if @err<>0
rollback tran
end
commit transaction
end transaction

---