update Sys_emplyee set Statisticsreports=stuff(replace(','+Statisticsreports,','+@parm,''),1,1,'')
我的那个SQL有点问题,有楼下这个:update 表 set Statisticsreports = replace(','+Statisticsreports+',',',''1'',','')
to: vivianfdlpw() 这个没有更新到.to:libin_ftsafe(子陌红尘) update 表 set Statisticsreports = replace(','+Statisticsreports+',',',''1'',','') 这样如果不去掉的不是最后一个的话,更新一次会在后面加了一个逗号
create table #t(Statisticsreports varchar(100)) insert into #t select '''1'',''2'',''3'''select * from #tdeclare @v varchar(10) set @v = '''3'''update #t set Statisticsreports = case when (Statisticsreports like @v+'%') then replace(Statisticsreports,@v+',','') when (Statisticsreports like '%'+@v) then replace(Statisticsreports,','+@v,'') else replace(Statisticsreports,','+@v+',',',') endselect * from #tdrop table #t
set Statisticsreports=stuff(replace(','+Statisticsreports,','+@parm,''),1,1,'')
set Statisticsreports = replace(','+Statisticsreports+',',',''1'',','')
to: vivianfdlpw()
这个没有更新到.to:libin_ftsafe(子陌红尘) update 表
set Statisticsreports = replace(','+Statisticsreports+',',',''1'',','')
这样如果不去掉的不是最后一个的话,更新一次会在后面加了一个逗号
vivianfdlpw() 你的是对的,刚我给的参数有问题,谢谢了!
同样感谢libin_ftsafe(子陌红尘)
insert into #t select '''1'',''2'',''3'''select * from #tdeclare @v varchar(10)
set @v = '''3'''update #t
set Statisticsreports = case when (Statisticsreports like @v+'%')
then replace(Statisticsreports,@v+',','')
when (Statisticsreports like '%'+@v)
then replace(Statisticsreports,','+@v,'')
else replace(Statisticsreports,','+@v+',',',')
endselect * from #tdrop table #t