sys.syscomments

Extending SQL's Inherent Hierarchical Processing Operation

This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include nonlinear data ordering, the renormalization of data to remove replicated data, and the processing of network structures.

Transactions

T-SQL GO statement

Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server

My client wants to standardize address information for existing and future addresses collected for their customers, particularly the street suffixes. The application used to enter and collect address information has the street suffix separated from the address field, but it is a textbox instead of a drop down list therefore things are not standardized. I know there are some options out there to standarize data, but they would like a less expensive alternative. Are there any functions in SQL Server that I can use to standardized data?

Get column names in a table

Script to get a table's columns

temp table in sysobjects

SELECT INTO with a Temp Table

Conditional Order By

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.