Regular Expressions 101

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

Open Workspace
  • .NET 10.0 (C#)
  • Match
-2

Regular Expression

@"
(\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