Sqlserver替换函数Replace

参考 https://www.cnblogs.com/gosky/p/4107400.html

 

--查询出含有“abc”的数据
 select REPLACE(name,'abc','123'),* from [dbo].[TEST]
 where name like '%abc%'

 --修改abc为123
update [dbo].[TEST]
 set name=REPLACE(name,'abc','123')
 where name like '%abc%'