INSERT INTO (1) 썸네일형 리스트형 [regex][mssql] INSERT | INSERT INTO expression /(INSERT+?(INTO|)\s+(.*?)|)SELECT\s+(.*?)\s*FROM\s+(.*?)\s*(WITH|)\(NOLOCK\)\s(WHERE\s(.*)\s*)?/g matches X - INSERT TPE_40C X - INSERT #TPE_40C O - INSERT TPE_40C SELECT C_COA FROM TPP_10C AS D WITH(NOLOCK) WHERE 1=1 AND C_COA = 1 GROUP BY C_COA O - INSERT INTO TPE_40C SELECT C_COA FROM TPP_10C AS D WITH(NOLOCK) WHERE 1=1 AND C_COA = 1 GROUP BY C_COA demo link https://regexr.com/44ndb 이전 1 다음