select PProduceID,SUBSTRING(PProduceID,3,len(PProduceID)) from dbo.Carton_BG_PProduceInfo
where PProduceID like '2015%'
select * into Carton_BG_PProduceInfo160113 from Carton_BG_PProduceInfo
update Carton_BG_PProduceInfo set PProduceID = SUBSTRING(PProduceID,3,len(PProduceID))
where PProduceID like '2015%'
update a set a.cCusPPerson=b.cCusPPerson from testclient a,UFDATA_303_2015.dbo.Customer b
where a.cCusCode=b.cCusCode
亲,沙发正空着,还不快来抢?
我要评论 / 展开表单