inserting values by checking the existing values
-
hi all, how to handle this case just i write in this way insert into e.empone values('kris45','sai','20','prg') where e.empid in (insert into d.deptone values ('20','dev','prg','kris45') where e.empid in (insert into p.profone values('prg','dev','kris45') where e.empid = d.empid and e.empid = p.deptid
sai krishna
-
hi all, how to handle this case just i write in this way insert into e.empone values('kris45','sai','20','prg') where e.empid in (insert into d.deptone values ('20','dev','prg','kris45') where e.empid in (insert into p.profone values('prg','dev','kris45') where e.empid = d.empid and e.empid = p.deptid
sai krishna
Get values in store procedure if not exists(Select * from empone where val1=@val1 and val2=val2 and val3=@val3 and val4=@val4) then write insert statement.
God Bless you. Always do good to others