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.

COALESCE Vs ISNULL

To switch or not to switch

More of computed columns

Return to Sender: Identity Values and Triggers

By quickly and easily obtaining the identity value, the OUTPUT clause of an INSERT statement can obtain the auto-generated identity value of a row, and so will allow the application to immediately reference the new row or add rows to another table that use the identity value as a foreign key reference.

Computed column

Predict the total count