Submitted by SarahC - 7 years ago
Remove GO and split for batch SQL text
Useful for when you need to convert a T-SQL MSSMS Server batch into individual SQL requests by removing the GO between them.
Dim SQLBatches As String() = Regex.Split(text, "(?:\s|\r|\n)+GO\s*(?:\r|\n)", RegexOptions.IgnoreCase)