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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)