你写的这句有错
应该是
update custinfo set superid=test.superid,corpid=test.corpid,fenju=test.fenju
from test
where corpname=test.corpname
go
应该是
update custinfo set superid=test.superid,corpid=test.corpid,fenju=test.fenju
from test
where corpname=test.corpname
go
use CustInfo
goupdate custinfo set superid=test.superid,corpid=test.corpid,fenju=test.fenju
from test inner join custinfo
on custinfo.corpname=test.corpname
go
set superid=test.superid,
corpid=test.corpid,
fenju=test.fenju
from custinfo , test
where custinfo.corpname=test.corpname