1.行头内容批量追加:
行头追加前:
SELECT ID, Name, ADDRESS
FROM Student AS
WHERE (ID = 3)
行头追加后:
strSQL += "SELECT ID, Name, Hometown
strSQL += " FROM Student AS
strSQL += "WHERE (ID = 3)
行头追加方法:
Ctrl+R打开【置换】窗口→【检索】项中输入 【^】 符号→【置换】项中输入需要置换的内容【strSQL += "】
→正规表现的复选框需要选中,点击【全置换】
2.行尾内容批量追加:
行尾追加前:
strSQL += "SELECT ID, Name, Hometown
strSQL += " FROM Student AS
strSQL += "WHERE (ID = 3)
行尾追加后:
strSQL += "SELECT ID, Name, Hometown ";
strSQL += " FROM Student AS ";
strSQL += "WHERE (ID = 3) ";
行尾追加方法:
Ctrl+R打开【置换】窗口→【检索】项中输入 【$】 符号→【置换】项中输入需要置换的内容【 ";】
→正规表现的复选框需要选中,点击【全置换】