批量替换SQL数据库中某一个表中的某些列的数据

时间:2015/12/1 10:14:00来源:互联网 作者:flyso 点击: 865 次

update   table1   set   text1=replace(text1,'list/任意位数的字符/','list/任意位数的字符/你好啊')    
    
  update   t   set   text1=reverse(stuff(reverse(text1)  
                                                                    ,charindex('.',reverse(text1))  
                                                                    ,0  
                                                                    ,reverse('list/任意位数的字符/你好啊')  
                                                                    )  
                                                        )            

Copyright © 2005 - 2016 flyso.cn. 飞搜 版权所有 鄂ICP备11002783号-3