具体语句如下:
UPDATE S200502
SET dishi = number
FROM phoneupdate
WHERE s200502.dishi = phoneupdate.oldphone
其中:
S200502表:
zj bj startdate starttime enddate endtime jfsc dishi
13598053054 12581307 20050201 22:14:18 20050201 22:14:53 35 2 phoneupdate表结构如下:
number cityname phoneno oldphone
1 省公司 000 19
UPDATE S200502
SET dishi = number
FROM phoneupdate
WHERE s200502.dishi = phoneupdate.oldphone
其中:
S200502表:
zj bj startdate starttime enddate endtime jfsc dishi
13598053054 12581307 20050201 22:14:18 20050201 22:14:53 35 2 phoneupdate表结构如下:
number cityname phoneno oldphone
1 省公司 000 19
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货