Posted by Erland Sommarskog on 04/25/06 00:42

(andyblum@gmail.com) writes:
> Check out the following link from the code project.
>
> http://www.codeproject.com/managedcpp/xpregex.asp
>
> It provides C++ external functions for SQL Server 2000 that I assume is
> usable from 2005 as well. Unlike some onelse who said that LIKE is
> faster it is not, this flies!

Yes, but in SQL 2005 you call functions written in a CLR language,
where you can use the Regexp classes in the .Net Framework. This is a
lot more effecient than calling extended stored procedures.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: [ANNOUNCE] XQuery Hacks
• Prev in forum: Re: Removing embedded SQL from database application
• Thread view: Re: SELECT and regular expression

[Reply to this message]