Re: Is there any REGEXP library for TSQL?


"Martijn Tonies" <m.tonies@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11mhdiekuhe26e9@xxxxxxxxxxxxxxxxxxxxx
> > >> 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?
>

I'm guessing the main reason is that in SQL 2000, it executes outside of SQL
Server, which means for every call there's delay as it has to call out of
its address space. SQL 2005 CLR code executes within the same memory space
as SQL Server.


>
> --
> 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
>
>


.

Relevant Pages

  • RE: DTS is blocked by XP
    ... When usung XP (extended procedures), the login you use to access the SQL ... server instance will require permissions within to run extended procedures. ... Look for setting permissiones in SQL. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sequential Number in an Update
    ... among Standard SQL, ... Like I said again - how would you code this NOW in SQL Server; ... You've already told us "NO CLR, ... having a Mail Exchanger ius not a problem for all the sites that are ...
    (comp.databases.ms-sqlserver)
  • Re: Yukon SQLCLR questions
    ... As we are talking about beta products, and is solely based on information ... things may be different by the time Yukon ships. ... Mike Epprecht, Microsoft SQL Server MVP ... on the machine or does it have a dedicated CLR? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005
    ... Phil Barber wrote: ... > 2005 the CLR is now supported in stored procedures and triggers. ... SQL procedure outperform the CLR version quite a lot. ...
    (borland.public.delphi.non-technical)
  • Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
    ... this is done via visual studio project settings. ... deploying CLR creates unessicary maintinence issues. ... or do i have to manualu upload the DLL in ...
    (microsoft.public.dotnet.framework.clr)