求批量修改语句 本人求个语句,关于 批量修改的 在roominf表里的roomname字段中 含'梅A'的字符的字段 ,批量改为'梅-A-' 谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update roominf set roomname=replace(roomname,'梅A','梅-A-') update roominfset roomname=(select replace(roomname,'梅A','梅-A-') as roomname from roominf where roomname like '%梅A') update roominfset roomname= (select replace(roomname,'梅A','梅-A-') as roomname from roominf where roomname like '%梅A') update tb set text1='梅-A-' where text1 like '%梅A' update tb set text1=replace(text1,'梅A','梅-A-') where text1 like '%梅A%' 如何查询到时间 请教各位 小弟有sqlserver问题,大侠们请进,在线等 请教:MS SQL有关时间的模糊查询 如何实现,下查询。。 求出最小公用料号 这句哪里有问题呢。 关于sql server的一些问题 运行vb的RDS或运行html与rds结合应用的程序为何要装上sql server7.0才执行? 数据库 没有服务器 求助 sql2005 Login failed for user 'sa' 新手问一个比较简单的SQL 求问~!!!
roominf
set
roomname=(select replace(roomname,'梅A','梅-A-') as roomname from roominf where roomname like '%梅A')
roominf
set
roomname=
(select replace(roomname,'梅A','梅-A-') as roomname from roominf where roomname like '%梅A')
update tb set text1='梅-A-' where text1 like '%梅A'
update tb set text1=replace(text1,'梅A','梅-A-') where text1 like '%梅A%'