[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_COA ORDER BY D.CN_COA
SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) GOOD BYE
SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) 1=1

SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) WHERE D.C_COA IN ( SELECT C_COA FROM TPE_04C WHERE C_COA = A)
INSERT TPE_04C SELECT D.CN_COA FROM TPE_04C AS D WITH(NOLOCK) WHERE D.C_COA IN ( SELECT C_COA FROM TPE_04C WHERE C_COA = A)

X - DELETE FROM TPE_04C WHERE C_COA=1

INSERT TPR_99C SELECT D.C_COA FROM TPR_88C AS D WITH(NOLOCK) WHERE D.C_COA = 1

demo link

https://regexr.com/44nak