Ultraedit-32 取代問題

以下為範例 "SELECT * FROM abc where 1=1" "SELECT * FROM test where 1=1" "SELECT * FROM ask where 1=1" "SELECT * FROM def where 1=1" "SELECT * FROM ggg" 取代為 "SELECT * FROM abc WITH (NOLOCK) where 1=1" "SELECT * FROM test WITH (NOLOCK) where... show more 以下為範例

"SELECT * FROM abc where 1=1"
"SELECT * FROM test where 1=1"
"SELECT * FROM ask where 1=1"
"SELECT * FROM def where 1=1"
"SELECT * FROM ggg"
取代為
"SELECT * FROM abc WITH (NOLOCK) where 1=1"
"SELECT * FROM test WITH (NOLOCK) where 1=1"
"SELECT * FROM ask WITH (NOLOCK) where 1=1"
"SELECT * FROM def WITH (NOLOCK) where 1=1"
"SELECT * FROM ggg WITH (NOLOCK)"

我知道在搜尋那邊輸入"SELECT *"這樣就可以找到我要取代的文字

把*當萬用字元，接著就是問題了，我要取代成怎樣才會變成萬用字元部分原封不動，... (NOLOCK)呢？
因為檔案很多，要一個一個取代說實在的。。。有點費時

請問有大大知道嗎？麻煩跟我說一下　　謝謝。
Update: where 1=1 只是舉例 後面的條件是不固定的

因為是有許多"檔案"要取代，加上並不是每個檔案都如此整理可以切割..
Update 2: 找到當行的 WHERE、插入WITH (NOLOCK)、移到下一行的開頭

但是這樣有可能會修改到SQL的修改與刪除命令，但是我只要修改查詢的命令而已，這...
1 answer 1