INSERT SELECT (1) 썸네일형 리스트형 [regex][mssql] INSERT SELECT, SELECT expression /(INSERT\s+(.*?)|)SELECT\s+(.*?)\s*FROM\s+(.*?)\s*(WITH|)\(NOLOCK\)\s(WHERE\s(.*)\s*)?/g matches SELECT D.CN_COA FROM TPE_04C D (NOLOCK) WHERE D.C_COA = A.C_COA SELECT D.CN_COA FROM TPE_04C D WITH(NOLOCK) WHERE D.C_COA = A.C_COA SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) WHERE D.C_COA = A.C_COA SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) WHERE D.C_COA = A.C_COA GROUP BY D.CN_CO.. 이전 1 다음