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

Please support RegExLib Sponsors

Sponsors

Regular Expression Details

Title Test Find SQL Title Detector
Expression
(CREATE|ALTER) +(PROCEDURE|PROC|FUNCTION|VIEW) *(\[(.*)\]|(.*))
Description
Expression to detect the name of the stored procedure / function / view, useful to detect automatically the name of the sproc the produced text in SQL
Matches
CREATE PROC[spTest], CREATE FUNCTION fnTest, ALTER PROCEDURE spTestOther
Non-Matches
DROP PROC xxx, CREATE CURSOR xxx
Author Rating: Not yet rated. Alejandro Cons
Source
Your Rating
Bad Good

Enter New Comment

Title

Name

Comment

Spammers suck - we apologize. Please enter the text shown below to enable your comment (not case sensitive - try as many times as you need to if the first ones are too hard):

Existing User Comments

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