Regular Expressions 101

insert[\s]+into[\s]+\([\s](?.?)[\s]\)[\s]+values[\s]+\((?.?)[\s]*\);

SQL injection regEx pattern

Matches european dates (DD.MM.YYYY[ HH:MM:SS]) and MS-SQL Timestamp ({ts 'YYYY-MM-DD HH:MM:SS'})

Splits t-sql script into separated commands. useful for executing with adocommand object

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

13 fields, 12 comma's from right (all left hand ones need to be ignored as they're part of the sql statements)

insert into table ( a, b, c ) values ( " insert into values (1,2,3)",1,2.3,"a,b" ); insert into table (ee,bb,cc) values (aa,234,"asj",2.3);

A regex to find the db wich you're quering against to.

Parse SQLALCHEMY_DATABASE_URI

matching any SQL query starting by "SELECT foo,bar FROM fool,baz {...}" this one is the good one. first one have a matching alowing * in the FROM statement.

SQL LIMIT REMOVE