34,576
社区成员
发帖
与我相关
我的任务
分享
create table #t (
myid int,
mystr varchar(20)
)
insert into #t (myid,mystr)
select 1,'aqwss' union all
select 1,'bqwss2' union all
select 1,'cqwe3ss4' union all
select 1,'eqwss' union all
select 1,'fqwess'
select *
from #t
update #t
set mystr=stuff(mystr,2,0,'s')
select *
from #t
update #T
set mystr=replace(mystr,'ss','AA')
select *
from #t
drop table #t
update temp set name=left(name,1)+'s'+right(name,len(name)-1)