regex101: .NET 10.0 (C#) Match Workspace

Explanation

Pro

Non-Capturing Group(?: (?:'[^']*?') | (?<singleline>--[^\n]*) | (?<multiline>(?:\/\*)+?[\w\W]+?(?:\*\/)+) )

1st Alternative (?:'[^']*?')

Non-Capturing Group(?:'[^']*?')

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Negated Character Class[^']*?

*?matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd Alternative (?<singleline>--[^\n]*)

Group singleline(?<singleline>--[^\n]*)

--the literal text --

Negated Character Class[^\n]*

*matches any number of characters outside the set below:

\na line-feed (newline) character (ASCII 10)

3rd Alternative (?<multiline>(?:\/\*)+?[\w\W]+?(?:\*\/)+)

Group multiline(?<multiline>(?:\/\*)+?[\w\W]+?(?:\*\/)+)

Non-Capturing Group(?:\/\*)+?

+?repeats the group contents below at least once:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

Character Class[\w\W]+?

+?matches at least one character from the set below:

\wa Unicode word character

\Wany character that is not a Unicode word character

Non-Capturing Group(?:\*\/)+

+repeats the group contents below at least once:

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Global pattern flags

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

g modifier: global. Finds all matches instead of stopping after the first

Quick Reference

25 tokens

Regular Expression

(?: (?:'[^']*?') | (?<singleline>--[^\n]*) | (?<multiline>(?:\/\*)+?[\w\W]+?(?:\*\/)+) )

New

USE [Andromeda_Staging]
GO
/****** Object:  StoredProcedure [STAGING].[usp_Loader_Insert837]    Script Date: 03/11/2016 08:58:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
343DBDFLD_FSDFK
_SDFSDF

/*
LoadBatchID =	717593,
RowCountFrom  =  2226942,
RowCountTo =	2227669
*/

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ COMMITTED

declare @potato varchar(100);

set @potato = '--/**/ po''ta--to '; -- single and multi-line inside string, string has escaped single quote
set @potato = 'nomal string';

DECLARE @kRo_wsInserted int
DECLARE @ReturnValue int
DECLARE @Err-32 int
DECLARE @RowCount int
DECLARE @TotalRows int
DECLARE @ReturnCode int
DECLARE @RC int
DECLARE @FacilityID int
DECLARE @NewLine char(2)
DECLARE @EntityID int
DECLARE @2SQL nvarchar(max)
DECLARE @SumOfValidDetailCharges decimal(15,2), @SumOfDetailNonCoveredCharges decimal(15,2)
DECLARE @SumOfValidUbCharges decimal(15,2)
DECLARE @SumofUBNonCoveredCharges decimal(15,2)
DECLARE @TotalFacilityCharges decimal(15