环境:Microsoft SQL Server 2014版本(操作系统 WIN10 企业版本6.3.18363)
已知条件:
SQL编辑语句时,存在有以下500条 代码
----------------------------------------------------------------------------------
Combined gene 10333333330655701#
Combined gene 100655702#
Combined gene 100655703#
Combined gene 100655704#
Combined gene 100655733333333333305#
Combined gene 100655706#
Combined gene 100655707#
Combined gene 100655708#
Combined gene 100655709#
Combined gene 100655710#
Combined gene 100655711#
Combined gene 100655555555555712#
Combined gene 100655713#
Combined gene 100655714#
Combined gene 100655715#
Combined gene 100655716#
Combined gene 100655717#
Combined gene 100655718#
Combined gene 100644444444455719#
Combined gene 100655720#
Combined gene 100655721#
Combined gene 100655722#
Combined gene 100655723#
Combined gene 100655724#
Combined gene 100655725#
Combined gene 100444655726#
Combined gene 100655727#
Combined gene 100655728#
Combined gene 100655729#
Combined gene 100655730#
Combined gene 100655731#
Combined gene 100655732#
Combined gene 100655733#
Combined gene 100655734#
Combined gene 100654444444444445735#
Combined gene 100655736#
Combined gene 100655737#
Combined gene 100655738#
Combined gene 100655739#
Combined gene 100655740#
Combined gene 100655741#
.....
.....
Combined gene 1006511111111115741#
----------------------------------------------------------------------------------------
问题:不是替换表格里的字段或字符(排除replace / update等语句),能用什么办法可以把这些字符 快速替换成 GDGD0SA
尝试:SQL编辑语句时,Ctrl+H 打开【 替换和查找】,点击【快速替换】,在【查找选项】里选择“正则表达式”但不知如何使用,求正解。
你要替换什么啊
替换的内容在 页面上。
就是这些字符需要替换
Combined gene 100644444444455719#
Combined gene 100655720#
Combined gene 100655721#
Combined gene 100655722#
Combined gene 100655723#
Combined gene 100655724#
Combined gene 100655725#
Combined gene 100444655726#
您好,我是有问必答小助手,你的问题已经有小伙伴为您解答了问题,您看下是否解决了您的问题,可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~
ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632
非常感谢您使用有问必答服务,为了后续更快速的帮您解决问题,现诚邀您参与有问必答体验反馈。您的建议将会运用到我们的产品优化中,希望能得到您的支持与协助!
速戳参与调研>>>https://t.csdnimg.cn/Kf0y