Regex (6) 썸네일형 리스트형 [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.. [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 [regex][mssql] CRATE TABLE expression /CREATE\s(TABLE)\s(#|@)+(.*?)\s\((.*)\)+(;|)/g matches O - CREATE TABLE #TPE_04C (C_COA CHAR(3)); O - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) O - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) X - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC) demo link https://regexr.com/44.. [regex][mssql] CREATE INDEX expression /(CREATE)\s(INDEX)\s(#|@)+(.*?)\s(ON)\s(#|@)+(.*?)\((.*)\)+(;|)/g matches X - CREATE TABLE #TPE_04C (C_COA CHAR(3)) X - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) X - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC) O - CREATE IN.. [regex][c#] new line expression /(\r\n|\r|\n)+/g matches RegExr was created by gskinner.com, and is proudly hosted by Media Temple. Edit the Expression & Text to see matches. Roll over matches or the expression for details. PCRE & Javascript flavors of RegEx are supported. The side bar includes a Cheatsheet, full Reference, and Help. You can also Save & Share with the Community, and view patterns you create or favor.. [jquery] 숫자만 입력받기 $("#code").keyup(function () { $(this).val($(this).val().replace(/[^0-9]/g, "")); }); 이전 1 다음