Loading

Table Relation

sujay anand

11y1.3k.NET

How to update two table while insert value into new table? For eg: I have table named table0,table1 and table2. And I have datas in table0. While inserting table1 how to update as the inserted value to be deleted from table0 and the value to be inserted in table2.?

2 Replies

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

sujay anand11y ago
Here in my code I am inserting at the same time I am updating another table. My prob is I want to Update two table while inserting a first table and first table is not empty.
0
Kunal Vaishya11y ago
Hi,

You can use trigger on INsertion for this, may be it will help you.

Regards,
Kunal.
0