update

[jiaguwen123]

好,请问使用update a set a.name = '国' from a,b where a.pro like b.pro'%' 更新a.pro右匹配b.pro的数据,为什么不行?要怎样修改才正确?

[you_tube]

b.proc + '%'

[yangqidong]

update a
from a inner join b on charindex(a.pro,b.pro)=1
set a.name = '国'

[htl258_Tony]

update a set a.name = '国' from a,b where a.pro like b.pro+'%'

[rucypli]

update a set a.name = '国'
from a,b 
where charindex(a.pro,b.pro)>0

[让你望见影子的墙]

update a set a.name = '国' from a,b where a.pro like b.pro+'%'

[百年树人]

update a 
set a.name = '国' 
from a,b 
where a.pro like b.pro+'%'

--或者

update a 
set a.name = '国' 
from a,b 
where charindex(b.pro,a.pro)>0'

[yangqidong]

update a set a.name = '国'
from a inner join b on  charindex(a.pro,b.pro)=1 

[ks_reny]

update a 
set a.name = '国' 
from a,b 
where charindex(b.pro,a.pro)>0'

[lihan6415151528]

update a set a.name = '国' from a,b where a.pro like b.pro+'%'