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,標題,標題,1,1,1,0,Fid,Sid,Tid,產品描述,縮略圖,1000,計量單位,單價,產品品牌,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 閱讀(94)
評論(0) 編輯 收藏