Loading

auto updation of one table through the updation of other tab

romasha ali

how to auto update or insert some of colum's data in one table through the updation of other table actually i made two tables namely 'transaction' and 'shipment' and they have some common columns and i insert data in 'shipment ' table on runtime now i want to update same columns automatically in 'transaction' table on runtime ,, how to do this kindly help

regards...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pramod Thakur10y ago
Hi Romash,

You can write a store procedure for it. I think there are some relation between both table.

Create Proc Procedure_Name
@Column1 datatype,
@Column2 datatype,
@Column3 datatype
as
Begin
Insert into shipment value(@Column1,@Column2,@Column3)
update transction set Column1=@Column1 where Column2=@Column2
End

Please mark as answer if it is useful to you.
0