Regular Expressions 101

Sponsors

Community Patterns

1

T-SQL find comments in script

Created·2024-04-04 08:50
Flavor·.NET 7.0 (C#)
Finds the comments in a t-sql (tsql) script
Submitted by Paw Jershauge
-2

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

Created·2023-02-15 21:12
Flavor·.NET 7.0 (C#)
Parses MS SQL Server version returned from executing SELECT @@version
Submitted by M Rivas

Community Library Entry

0

Regular Expression
Created·2020-12-14 09:23
Flavor·PCRE (Legacy)

/
[a-zA-z\-]+( )+?=( )+?(:id)( +)?and|and( +)?[a-zA-z\-]+( )+?=( )+?(:id)$|where( )+?[a-zA-z\-]+( )+?=( )+?(:id)$
/
gmi
Open regex in editor

Description

no description available

Submitted by anonymous