O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

UDF Cookbook

The section that follows is a cookbook of UDFs I've written to address various business needs. These types of sections are always a lot of fun for me because I get to roll out some of my homegrown code and show the world what I've been up to. One of the design goals of this book is to provide you with code that has intrinsic value apart from the book—code that you could drop into place on your own systems and put to work. That's what this section is about. It's about demonstrating some of the techniques we've been talking about (and even a few we haven't) by working through some real-world code.

An Improved SOUNDEX() Function

The built-in SOUNDEX() function is certainly a handy tool, but it uses a fairly primitive soundex algorithm, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required