regex101: T-SQL find text blocks in script

Regular Expression

(?<text>N?'((?:''|[^'])*)'|N?"((?:""|[^"])*)")

New

USE [master]
GO

IF OBJECT_ID('dbo.sp_foreach_db') IS NOT NULL
	DROP PROCEDURE [dbo].[sp_foreach_db] 
GO

CREATE PROCEDURE [dbo].[sp_foreach_db] 
(
	@tsql NVARCHAR(MAX) = NULL
	,@replacedatabasenamepattern NVARCHAR(20) = N'?'

	,@break_on_error BIT = 1

	,@db_name_like NVARCHAR(128) = NULL
	,@db_name_in NVARCHAR(4000) = NULL
	,@db_name_not_in NVARCHAR(4000) = NULL
	,@db_use_system_db BIT = 0
	,@db_use_temp_db BIT = 0

	,@push_info_msg BIT = 1
)
WITH EXECUTE AS CALLER 
AS
/*
Version:	1.0.1.0
Developer:	Paw Jershauge
Created:	18-03-2016 13:01:00
*/
BEGIN
	IF @tsql IS NULL
		RETURN 0;
	 
	SET NOCOUNT ON;
	DECLARE @dbtsql NVARCHAR(MAX)
		,@firecode NVARCHAR(MAX)
		,@db_name NVARCHAR(128)
		,@dbnames NVARCHAR(MAX) = N''
		,@has_replacement BIT = 0
		,@msg_str NVARCHAR(2044)

	SET @dbtsql = N'SELECT @dbnames += [name] + CHAR(10) FROM [master].[sys].[databases] WHERE [state] = 0'
	SET @dbtsql += IIF(ISNULL(@db_use_temp_db, 0) = 1, N'', N' AND [database_id] <> 2')
	SET @dbtsql += IIF(ISNULL(@d

Substitution

USE [master]
GO

IF OBJECT_ID('dbo.sp_foreach_db') IS NOT NULL
	DROP PROCEDURE [dbo].[sp_foreach_db] 
GO

CREATE PROCEDURE [dbo].[sp_foreach_db] 
(
	@tsql NVARCHAR(MAX) = NULL
	,@replacedatabasenamepattern NVARCHAR(20) = N'?'

	,@break_on_error BIT = 1

	,@db_name_like NVARCHAR(128) = NULL
	,@db_name_in NVARCHAR(4000) = NULL
	,@db_name_not_in NVARCHAR(4000) = NULL
	,@db_use_system_db BIT = 0
	,@db_use_temp_db BIT = 0

	,@push_info_msg BIT = 1
)
WITH EXECUTE AS CALLER 
AS
/*
Version:	1.0.1.0
Developer:	Paw Jershauge
Created:	18-03-2016 13:01:00
*/
BEGIN
	IF @tsql IS NULL
		RETURN 0;
	 
	SET NOCOUNT ON;
	DECLARE @dbtsql NVARCHAR(MAX)
		,@firecode NVARCHAR(MAX)
		,@db_name NVARCHAR(128)
		,@dbnames NVARCHAR(MAX) = N''
		,@has_replacement BIT = 0
		,@msg_str NVARCHAR(2044)

	SET @dbtsql = N'SELECT @dbnames += [name] + CHAR(10) FROM [master].[sys].[databases] WHERE [state] = 0'
	SET @dbtsql += IIF(ISNULL(@db_use_temp_db, 0) = 1, N'', N' AND [database_id] <> 2')
	SET @dbtsql += IIF(ISNULL(@d