导入数据的sql语句，两表互导

 导入数据的sql语句，两表互导

insert into Product(C_ID,Pname,Ptitle,Ptype,IsProduct,onLine,FisrtSort,SecSort,Sort,Introduce,picPath1,Effective,Price,Pcount,United,UnitPrice,Brand,ISsuseTime,FlushTime,IsPass,PassTime,PassAdmin,IsDelete)
select C_ID,标题,标题,'1','1','1',Fid,Sid,Tid,产品描述,产品图,1200,单价,供货总量,'',单价,产品品牌,getdate(),getdate(),'1',dateadd(day,round(100*rand(),0),getdate()),'admin',0 from ImportData..ProContent

转载于:https://www.cnblogs.com/bestsaler/archive/2009/05/26/1835632.html