SQL Server

MSDN T-SQL Wiki

The mods and admins at the MSDN site have started a wiki so you don't ask annoying questions that you should already know the answer to. Hmmm....

RegEx for SQL Server .dll

This is a DLL I created to allow RegEx to be used via UDF in SQL Server. It will allow you to generate a UDF called 'fRegExMatcher' that return a bit value based on the field/variable and RegEx pattern you provide as argument to the function. You'll need to download the file, and issue the following command in your instance: CREATE ASSEMBLY SQLTools FROM '<path>\SQLDataImportTools.dll' CREATE FUNCTION fRegExMatcher ( @Pattern nvarchar(max), @MatchString nvarchar(max) ) RETURNS BIT AS EXTERNAL NAME SQLTools.UserDefinedFunctions.RegExIsMatch

SQL Cursor for Parsing Address Data

Yeah, more cursors.