循环批量插入数据的SQL语句:
insert into A(CuisID,StoID)
select 数据值, StoID
from B
where StoID not in (select StoID from A)
循环批量插入数据的SQL语句:
insert into A(CuisID,StoID)
select 数据值, StoID
from B
where StoID not in (select StoID from A)