Re: SELECT and regular expression
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 24 Apr 2006 21:42:34 +0000 (UTC)
(andyblum@xxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- SELECT and regular expression
- From: Martin Lukasik
- Re: SELECT and regular expression
- From: andyblum
- SELECT and regular expression
- Prev by Date: Re: Removing embedded SQL from database application
- Next by Date: [ANNOUNCE] XQuery Hacks
- Previous by thread: Re: SELECT and regular expression
- Next by thread: No distinct in a select into stement ?
- Index(es):
Relevant Pages
|
