实现这样的字符串替换，有什么办法？
表中有一些类似操作日志的记录，如
select * from customers where customerid= 'TCANG '
delete from orders where employeeid=9
insert into customers values( 'AYWOT ', 'Pdodgtrwa Ikuqyyayj,Onomkn Jagerg ', 'Lgnuuf Bjxjxg ', 'Pipzfb Yczzkh 692 ', 'Iiyhgt ', 'NI ', '00328 ', 'Lbwywwd ', '57-8689-33306113 ')
update orders set freight=009.91 where orderid=17050
我想把它们中所有的具体值都替换成我所指定的一个字符串，如SOMEVALUE：
select * from customers where customerid=SOMEVALUE
delete from orders where employeeid=SOMEVALUE
insert into customers values(SOMEVALUE)
update orders set freight=SOMEVALUE where orderid=SOMEVALUE
我打算用游标对每条这种记录做某个操作，达到这个目的。
有什么好的方案吗？
由于要替换的内容长度、位置都不确定，所以似乎有些复杂。
[解决办法]
没看懂。。。
[解决办法]
不太明白．
[解决办法]
/*
我只写了替换等于的情况，其它情况楼主参照写：
*/
declare @Test table (ha varchar(8000))
insert @Test select 'select * from customers where customerid= ' 'TCANG ' ' '
insert @Test select 'delete from orders where employeeid = 9 '
insert @Test select 'update orders set freight= 009.91 where orderid =17050 '
while exists (select 1 from @Test where charindex( ' = ', ha) > 0) update @Test set ha = replace(ha, ' = ', '= ') where charindex( ' = ', ha) > 0
while exists (select 1 from @Test where charindex( '= ', ha) > 0) update @Test set ha = replace(ha, '= ', '= ') where charindex( '= ', ha) > 0
update @Test set ha = replace(ha, '= ', ' = ') where charindex( '= ', ha) > 0
update @Test set ha = ha + ' ' --这个空格很重要
declare @Replace varchar(100)
set @Replace = 'SOMEVALUE '
select * from @Test
/*
select * from customers where customerid = 'TCANG '
delete from orders where employeeid = 9
update orders set freight = 009.91 where orderid = 17050
*/
while exists (select 1 from @Test where charindex( ' = ', ha) > 0) update @Test set ha = stuff(ha, charindex( ' = ', ha),charindex( ' ', ha, charindex( ' = ', ha) + 3) - charindex( ' = ', ha), '= ' + @Replace) where charindex( ' = ', ha) > 0
select * from @Test
/*
select * from customers where customerid=SOMEVALUE
delete from orders where employeeid=SOMEVALUE
update orders set freight=SOMEVALUE where orderid=SOMEVALUE
*/
[解决办法]
为什么不考虑考虑正则实现呢？
[解决办法]
up
