INSERT INTO tableB b SELECT a.l_desc, a.s_desc FROM tableA a where on a.id = b.id
tableB
insert
Update
update b set b.l_desc=a.l_desc,b.s_desc=a.s_desc from tableB as b inner join tableA a where a.id = b.id
update b set l_desc=a.l_desc,s_desc=a.s_desc from tableB , tableA a where a.id = b.id
UPDATE tableB set l_desc=a.l_desc,s_desc=a.s_desc FROM tableA a WHERE a.id=tableB.id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)