RegExLib.com - The first Regular Expression Library on the Web!

Please support RegExLib Sponsors

Sponsors

Expressions by User

   Displaying page 1 of 1 pages; Items 1 to 1
Title Test Details SQL Batch parser (isql-like)
Expression
(?:^.*\r*\n*)*?(?:(?=^\s*GO\s*$)|$)
Description
simulates sql batch parsing behavior of isql.exe given an inputfile. The regex matches correspond to sql batches (arbitrary text) which are separated by the GO keyword on a line by itself, but not including this GO keyword. Make sure multiline switches are enabled. (One could use this regex to loop over the matches, executing one sql batch at a time, esp in situations where a Split() function is unavailable).
Matches
[input form not adequate for sufficient matching example]
Non-Matches
[input form not adequate for sufficient matching example]
Author Rating: Not yet rated. Jon Schoning
   Displaying page 1 of 1 pages; Items 1 to 1

Copyright © 2001-2025, RegexAdvice.com | ASP.NET Tutorials