导入数据的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

posted on 2009-05-26 14:35  bestsaler  阅读(228)  评论(0编辑  收藏  举报