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... 顯示更多 以下為範例

"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 *"這樣就可以找到我要取代的文字

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

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

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

但是這樣有可能會修改到SQL的修改與刪除命令,但是我只要修改查詢的命令而已,這樣應該沒有辦法用大大說的方法吧!?
1 個解答 1