Posted by Martijn Tonies on 11/02/05 14:51

> >> In SQL 2005, there is no better support in T-SQL, but you can call a
CLR
> >> routine that uses the RegEx classes in .Net.
> >
> > I guess for SQL 2000, you could use a non-COM library as an "extended
> > procedure"?
>
> But performance would be awful and the code would be messy.

I've never written any extended procedures, so perhaps you could
explain why this would give awful performance?

I imagine the call could be as:

select ...
from ...
where myregexp_match(mycolumn, myexpression, myvalue)

Why would this be any slower than COM or .NET? Isn't this partly
what extended procedures were meant for?


--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

• Next in forum: Re: Need help with big data mart model
• Prev in forum: Re: Is there any REGEXP library for TSQL?
• Thread view: Re: Is there any REGEXP library for TSQL?

[Reply to this message]