Regular Expressions in SQL Server servers?

by

For SQL Server 2000 (and any other 32 bit edition of SQL Server), there is xp_pcre, which introduces Perl compatible regular expressions as a set of extended stored procedures. I’ve used it, it works.

The more recent versions give you direct access to the .NET integrated regular expressions (this link seems to be dead, here is another one: MSDN: How to: Work with CLR Database Objects).

More Related Contents:

  1. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  2. Check if table exists in SQL Server
  3. Using RegEx in SQL Server
  4. SQL Server query to find all permissions/access for all users in a database
  5. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  6. Why use the INCLUDE clause when creating an index?
  7. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  8. Is it possible to force row level locking in SQL Server?
  9. SQL Server GUID sort algorithm. Why?
  10. What happens to the primary key Id when it goes over the limit?
  11. Drop primary key using script in SQL Server database [duplicate]
  12. SQL Server recursive query
  13. nvarchar(max) vs NText
  14. INFORMATION_SCHEMA vs sysobjects
  15. “Prevent saving changes that require the table to be re-created” negative effects
  16. What are row, page and table locks? And when they are acquired?
  17. Table Valued Function Killing My Query Performance
  18. Comma separated results in SQL
  19. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  20. Understanding PIVOT function in T-SQL
  21. Which are more performant, CTE or temporary tables?
  22. Why is it considered bad practice to use cursors in SQL Server?
  23. Import Excel spreadsheet columns into SQL Server database
  24. CAST and IsNumeric
  25. Find index of last occurrence of a sub-string using T-SQL
  26. SQL Server 2008 Empty String vs. Space
  27. SQL Query to find the last day of the month
  28. SQL Server, convert a named instance to default instance?
  29. In SQL Server, how can I find everywhere a column is referenced?
  30. Using Full-Text Search in SQL Server 2008 across multiple tables, columns

Leave a Comment