SQLCLR
In this post: SoundEx in Sql Server SimMetrics Adding string Metric functions in MS Sql Server Evaluating metric accuracy and comparing Metrics Conclusion + code Quite often we come across a requirement where we may need to perform some sort of fuzzy string grouping or data correlation. For example, we may want to correlate the customer records of a database by identifying records that are similar but not necessarily exactly the same (due to spelling mistakes for example). Obviously a simple group by, will not successfully group such data. We will need to employ what...
Have you been shying out of putting extra functions on your SQL Server 2005 using SQL CLR simply because you would like to avoid DLL Hell?! Well, the good news is that you need not be so worried, since SQL Server does not link to the dll itself, but instead it embeds the assembly in the database. What's even better is that you can deploy your assembly by simply scripting it. Lets do this with an example, in the previous post there is a sample that shows how to create support for regular expressions using SQL CLR....