Regular Expressions 101

Community Patterns

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

-2

Regular Expression
.NET 7.0 (C#)

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

Description

Parses MS SQL Server version returned from executing SELECT @@version

Submitted by M Rivas - a year ago