regex101: Parsing result of SQL Server version (SELECT @@VERSION)

Group 1(\d{4})

\d{4}a Unicode decimal digit, repeated exactly 4 times

.any Unicode character (except for line terminators)

Group 2($.*?$)

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

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

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

.any Unicode character (except for line terminators)

Non-Capturing Group(?:$.*$)

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

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

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

.any Unicode character (except for line terminators)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

.any Unicode character (except for line terminators)

Group 3(\d+\.)?

?repeats the group contents below at most once:

\d+a Unicode decimal digit, repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 4(\d+\.)?

?repeats the group contents below at most once:

\d+a Unicode decimal digit, repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 5(\d+\.)?

?repeats the group contents below at most once:

\d+a Unicode decimal digit, repeated at least once

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group 6(\*|\d+)

1st Alternative\*

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

2nd Alternative\d+

\d+a Unicode decimal digit, repeated at least once

Non-Capturing Group(?:.*?)

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

Non-Capturing Group(?:(\w+).Edition)

Group 7(\w+)

\w+a Unicode word character, repeated at least once

.any Unicode character (except for line terminators)

Editionthe literal text Edition (case sensitive)

Non-Capturing Group(?:.*?)

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

Non-Capturing Group(?:Windows.(\w+.\d+.\w+))

Windowsthe literal text Windows (case sensitive)

.any Unicode character (except for line terminators)

Group 8(\w+.\d+.\w+)

\w+a Unicode word character, repeated at least once

.any Unicode character (except for line terminators)

\d+a Unicode decimal digit, repeated at least once

.any Unicode character (except for line terminators)

\w+a Unicode word character, repeated at least once

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

Search reference

Regular Expression

(\d{4}).(\(.*?\)).(?:\(.*\)).-.(\d+\.)?(\d+\.)?(\d+\.)?(\*|\d+)(?:.*?)(?:(\w+).Edition)(?:.*?)(?:Windows.(\w+.\d+.\w+))

New

Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (X64)   Nov  1 2020 00:48:37   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)