Using a regular expression function on SQL Server
Before you begin
- You have deployed the regular expression function to the SQL server.
- You have tested the regular expression.
- You have selected the Profiling perspective.
About this task
Here
is the code used in this example:
Using System;
Using Microsoft.SqlServer.Server;
Using System.Text.RegularExpressions;
Public partial class RegExBase
{
[SqlFunction(IsDeterministic = true, IsPrecise = true)]
Public static int RegExMatch( string matchString , string pattern)
{
Regex r1 = new Regex(pattern.TrimEnd(null));
if (r1.Match(matchString.TrimEnd(null)).Success == true)
{
return 1 ;
}
else
{
return 0 ;
}
Using
}
};Procedure
-
Double-click Regular Expression Matching, or right-click
it and select Open from the contextual menu.
The corresponding view displays the indicator metadata and its definition.
You must add to the list of databases the database for which you want to define a query template. This query template will compute the regular expression matching. -
Click the Edit... button next to the new field.
The Edit expression dialog box is displayed.
-
Click the save icon
on top of the editor.
Results
For more detailed information on how to declare a regular expression function in the Studio, see Defining a query template for a specific database and Declaring a User-Defined Function in a specific database.