Regular Expressions 101

SELECTthe literal text SELECT (case insensitive)

\s+any whitespace character, repeated at least once

Group 1((?:.(?!SELECT))*)

Non-Capturing Group(?:.(?!SELECT))*

*repeats the group contents below any number of times:

.any character

Negative Lookahead(?!SELECT)

SELECTthe literal text SELECT (case insensitive)

\s+any whitespace character, repeated at least once

FROM INSERTEDthe literal text FROM INSERTED (case insensitive)

Global pattern flags

s modifier: single line. Allows a dot to match line terminators

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

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

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

SELECT\s+((?:.(?!SELECT))*)\s+FROM INSERTED

New

SELECT 1 FROM INSERTED i

SELECT 'Hello, world!' FROM INSERTED i

SET @foo = (SELECT @@userid)

SELECT * FROM INSERTED i

SELECT
	One,
	Two,
	Three, Four,
	Five,
	Six, Seven, Eight,
	Nine, Ten
FROM INSERTED i

SET @bar = (SELECT TOP(1) PatronID FROM INSERTED i)