Extracting words of a string with removal of unwanted punctuations.
This is a flexible function to extract words from a string and tested on both SQL 2000 and 2005
As you see the logic of this function is very simple. Maybe the update statement seems strange
to beginners because it does not update any field of underlying table; it removes all unwanted
punctuations from @s. In fact the replace function will execute for each punctuation that is in
@UnwantedPunctuations. The WHILE loop will execute repeatedly to extract words and put them into output table (@out).
For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.