CREATE TABLE test ( ID INT IDENTITY(1,1), NAME VARCHAR(20) )INSERT INTO test(NAME) VALUES ('杨天天') INSERT INTO test(NAME) VALUES ('杨天') INSERT INTO test(NAME) VALUES ('天天杨') INSERT INTO test(NAME) VALUES ('天杨')--SELECT * FROM testUPDATE test SET NAME=REPLACE(NAME,'天','地')
CREATE TABLE test
(
ID INT IDENTITY(1,1),
NAME VARCHAR(20)
)INSERT INTO test(NAME) VALUES ('杨天天')
INSERT INTO test(NAME) VALUES ('杨天')
INSERT INTO test(NAME) VALUES ('天天杨')
INSERT INTO test(NAME) VALUES ('天杨')--SELECT * FROM testUPDATE test SET NAME=REPLACE(NAME,'天','地')
set name =stuff(name,'天','地')
update table set name = replace(name , '天' , '地')