update dbo.IST_L_Monthlysales
set dbo.IST_L_Monthlysales.dealerid = b.dealerid
from dbo.IST_L_Monthlysales,dbo.dealer b
也不行,这个也会只把dealerid更新为deale表中最后一个dealerid
--既然这样,何必写那么多(select top 1 dealerid from dbo.dealer where
dealerid not in (select dealerid from dbo.IST_L_Monthlysales )) b
好麻烦哦
直接
update dbo.IST_L_Monthlysales
set dbo.IST_L_Monthlysales.dealerid = b.dealerid
from dbo.IST_L_Monthlysales,b
--这样更新就会按照物理顺序,更新IST_L_Monthlysales的dealerid等于b.dealerid
是这样,sales表里,有销售信息,我不想清除,我只是想dealer表里的dealer替换掉所有的原来的dealer,至于替换顺序,规则怎么都行。而且我发现插入新数据好像行不通,我的代码写到这了,但是有问题,不知道怎么改
update dbo.IST_L_Monthlysales
set dbo.IST_L_Monthlysales.dealerid = b.dealerid
from (select top 1 dealerid from dbo.dealer where
dealerid not in (select dealerid from dbo.IST_L_Monthlysales )) b