insert into Product([P_ID],[C_ID],[Pname],[Ptitle],[Ptype],[IsProduct],[onLine],[IsSecrecy],[FirstSort],[SecSort],[Sort],
[Introduce],[picPath1],[Effective],[United],[UnitPrice],[Brand],[IssuseTime],[FlushTime],[IsPass],[PassTime],[PassAdmin],[isdelete])
select replace(newid(),'-',''),C_ID,標(biāo)題,標(biāo)題,1,1,1,0,Fid,Sid,Tid,產(chǎn)品描述,縮略圖,1000,計(jì)量單位,單價(jià),產(chǎn)品品牌,getdate(),getdate(),1,getdate(),'admin',0 from ProContent
文章來源:
http://www.cnblogs.com/wangdetian168/archive/2008/09/25/1298661.html
posted on 2010-09-29 13:28
sanmao 閱讀(92)
評(píng)論(0) 編輯 收藏