update update a from a inner join b on charindex(a.pro,b.pro)=1set a.name = '国' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update a set a.name = '国' from a,b where a.pro like b.pro+'%' 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' update a set a.name = '国'from a inner join b on charindex(a.pro,b.pro)=1 update a set a.name = '国' from a,b where charindex(b.pro,a.pro)>0' update a set a.name = '国' from a,b where a.pro like b.pro+'%' sp3补丁安装问题(急!!!!!!!!!!!!!!) 企业管理器里如何不显示系统表或是存储过程? sqlserver 2000突然访问缓慢,经常超时 SQL筛选求高人指点 关于在function中调用sp_executesql出错的问题! SQL综合查询,急急急 线上系统改表结构---要求不停机 一个联接错误,如何修改。在线等--------------100分 简单问题 怎样比较时间在1分钟以内的? view? 请教各位高手关于一段更新语句的写法
from a,b
where charindex(a.pro,b.pro)>0
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'
update a set a.name = '国'
from a inner join b on charindex(a.pro,b.pro)=1
update a
set a.name = '国'
from a,b
where charindex(b.pro,a.pro)>0'
update a set a.name = '国' from a,b where a.pro like b.pro+'%'