環境：Microsoft SQL Server 2014版本（作業系統 WIN10 企業版本6.3.18363）
已知條件：
SQL編輯陳述句時，存在有以下500條 代碼，就是以下的每一行字符需要快速替換為 GDGDGSA
----------------------------------------------------------------------------------
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 打開【 替換和查找】，點擊【快速替換】，在【查找選項】里選擇“正則運算式”但不知如何使用，求正解。如果這個方法行不通的話，還有什么辦法實作要求。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/280113.html
標籤：疑難問題