regex101: PCRE (Legacy) Match Workspace

Group i_cl(?<i_cl>insert (?: \s (?: into | bulk ))?)

insert the literal text insert (case insensitive)

Non-Capturing Group(?: \s (?: into | bulk ))?

?repeats the group contents below at most once:

\sany whitespace character

Non-Capturing Group(?: into | bulk )

1st Alternative into

into the literal text into (case insensitive)

2nd Alternative bulk

bulk the literal text bulk (case insensitive)

\sany whitespace character

Condition(?(?=openquery) (?: (?<i_oq>openquery) \s $ (?<i_oq_srv>\S+) \, \s \' .*? \'$ ) | (?: (?<i_tbl>\S+) ) )

Uses the first branch if the lookaround matches

Positive Lookahead(?=openquery)

openquerythe literal text openquery (case insensitive)

If the condition is true, match this branch: (?: (?<i_oq>openquery) \s $ (?<i_oq_srv>\S+) \, \s \' .*? \'$ )

Non-Capturing Group(?: (?<i_oq>openquery) \s $ (?<i_oq_srv>\S+) \, \s \' .*? \'$ )

Group i_oq(?<i_oq>openquery)

openquerythe literal text openquery (case insensitive)

\sany whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group i_oq_srv(?<i_oq_srv>\S+)

\S+any non-whitespace character, repeated at least once

\,the literal , (44₁₀ / 54₈ / 2C₁₆)

\sany whitespace character

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

.*?any character (except for line terminators), repeated any number of times

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Otherwise, match this branch: (?: (?<i_tbl>\S+) )

Non-Capturing Group(?: (?<i_tbl>\S+) )

Group i_tbl(?<i_tbl>\S+)

\S+any non-whitespace character, repeated at least once

.*?any character (except for line terminators), repeated any number of times

\sany whitespace character

select the literal text select (case insensitive)

\sany whitespace character

.*?any character (except for line terminators), repeated any number of times

Non-Capturing Group(?: (?<f_cl>from) \s (?(?=openquery) (?: (?<f_oq>openquery) \s $ (?<f_oq_srv>\S+) \, \s \' (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) ) .* \'$ ) | (?: (?<f_tbl>\S+) ) ) )+

+repeats the group contents below at least once:

Group f_cl(?<f_cl>from)

fromthe literal text from (case insensitive)

\sany whitespace character

Condition(?(?=openquery) (?: (?<f_oq>openquery) \s $ (?<f_oq_srv>\S+) \, \s \' (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) ) .* \'$ ) | (?: (?<f_tbl>\S+) ) )

Uses the first branch if the lookaround matches

Positive Lookahead(?=openquery)

openquerythe literal text openquery (case insensitive)

If the condition is true, match this branch: (?: (?<f_oq>openquery) \s $ (?<f_oq_srv>\S+) \, \s \' (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) ) .* \'$ )

Non-Capturing Group(?: (?<f_oq>openquery) \s $ (?<f_oq_srv>\S+) \, \s \' (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) ) .* \'$ )

Group f_oq(?<f_oq>openquery)

openquerythe literal text openquery (case insensitive)

\sany whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group f_oq_srv(?<f_oq_srv>\S+)

\S+any non-whitespace character, repeated at least once

\,the literal , (44₁₀ / 54₈ / 2C₁₆)

\sany whitespace character

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

Non-Capturing Group(?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) )

.+?any character (except for line terminators), repeated at least once

Group f_oq_cl(?<f_oq_cl>from|join)

1st Alternativefrom

fromthe literal text from (case insensitive)

2nd Alternativejoin

\sany whitespace character

Group f_oq_tbl(?<f_oq_tbl>\S+)

.*any character (except for line terminators), repeated any number of times

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Otherwise, match this branch: (?: (?<f_tbl>\S+) )

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Search reference

Regular Expression

(?<i_cl>insert (?: \s (?: into | bulk ))?) \s

  (?(?=openquery) (?:
      (?<i_oq>openquery) \s \(
        (?<i_oq_srv>\S+) \, \s \'
        .*?
        \'\)
    ) 
    | (?:
      (?<i_tbl>\S+)
    )
  )

.*? \s select \s .*?
(?:
(?<f_cl>from) \s

(?(?=openquery) (?:
  (?<f_oq>openquery) \s \(
    (?<f_oq_srv>\S+) \, \s \'
    (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) )
    .* \'\)
  ) 
  | (?: (?<f_tbl>\S+) )
)
)+

Unit Tests

There are no unit tests, click to add some.