Darrell dazinator
dazinator
/ ParseSemVerString.sql
Last active
October 1, 2015 14:27
T-SQL function that takes a Semantic Version number string (see semver.org) and returns its component parts - Major, Minor, Patch, PreReleaseLabel and BuildMetadata
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create function dbo.ParseSemVerString | |
| ( | |
| -- a semantic version number string that meets specification described here: http://semver.org/ | |
| @versionString NVARCHAR(300) | |
| ) | |
| returns @T table(Major int, Minor int, Patch int, PreReleaseLabel nvarchar(200), BuildLabel nvarchar(200)) | |
| as | |
| begin | |
| declare @segmentDelimiter char(1) |
NewerOlder