原创

SQL update 语句

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

正文到此结束
本文目录