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

摘要： 把自身ID与下级数据ID 放到一个集合列表中 Select AreaID from Area where PrentID=@CityId union select AreaID=@CityId 阅读全文