SQL SERVER 2005 .NET UDF

using System;using System.Text.RegularExpressions;using Microsoft.SqlServer.Server;public partial class UserDefinedFunctions{ [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic = true,IsPrecise = true)] public static bool RegExIsMatch(string pattern,string matchString) { // 在此处放置代码 Regex reg = new Regex(pattern.TrimEnd(null)); return reg.Match(matchString.TrimEnd(null)).Success; }};use AdventureWorks GO CREATE ASSEMBLY UDFFROM 'C:/Users/Roy/Documents/Visual Studio 2008/Projects/UDF/UDF/bin/Release/UDF.dll'CREATE FUNCTION fCLRExample( @Pattern nvarchar(max),@MatchString nvarchar(max))RETURNS BITAS EXTERNAL NAME UDF.UserDefinedFunctions.RegExIsMatchSELECT ContactID,FirstName,LastName,EmailAddress,PhoneFROM Person.ContactWHERE DBO.fCLRExample('[a-zA-Z0-9_/-]+@([a-zA-Z0-9_/-]+/.)+(com|org|edu|mil|net|cn)',EmailAddress)=1