Regular Expressions 101

Group 1(UNION ALL\D*?historical;)

UNION ALLthe literal text UNION ALL (case sensitive)

\D*?any character that's not a digit, repeated any number of times

historical;the literal text historical; (case sensitive)

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(UNION ALL\D*?historical;)

New

@b =
    SELECT      *
    FROM        @e;
    UNION ALL
    SELECT      *
    FROM        @c_historical;


@r =
    SELECT      *
    FROM        @f;
    UNION ALL
    SELECT      *
    FROM        @y_historical;

Substitution

\/\*\1\*\/