Click here to Skip to main content
15,900,254 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
create table Test1
(
WRO varchar(10),
Test_No varchar(10),
TestDate datetime
);

insert into Test1(WRO,TestDate) values('T0001',now());

create table Test2
(
WRO varchar(10),
Test_No varchar(10),
Test2Date datetime,
TestAmount varchar(10)
);
I have to update and Insert on Test1 Test_No after insert on Test2 table Test_No both have common field WRO.

insert into Test2 values('DSK','400',now(),3000);
insert into Test2 values('T0001','200',now(),3000);
if wro no of test2 table not match with test1 then insert query should be fired in test1 table
Posted

1 solution

read this[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900