begin try
begin tran
update table1 set col1=@col1 where col1=@col1
insert into table2 (col1,col2,DTS) values (@col1,@col2,GETDATE())
commit tran
//I think we retunr Return 1
end try
begin catch
rollback tran
// return -1
end catch
but it getting return 2