SQL Server 2005 Tricks

Miscellaneous SQL Server scripts

SQL Server - left join data sums/counts/averages to date range to account for zero days or zero weeks

posted @ Tuesday, September 29, 2009 10:32 AM | Feedback (0)

List All Primary Keys and Foreign Keys

posted @ Thursday, October 23, 2008 3:49 AM | Feedback (0)

find columns and tables in a view

posted @ Tuesday, April 29, 2008 4:54 AM | Feedback (0)

Add a column to a table unless it already exists

posted @ Thursday, March 01, 2007 6:34 AM | Feedback (1)

Writing CLR Stored Procedures in C# - Introduction to C#

posted @ Monday, July 17, 2006 5:13 PM | Feedback (0)

dynamic SQL string execution

posted @ Sunday, July 16, 2006 4:01 PM | Feedback (0)

Find any datasbase Column by partial Name in any User Table

posted @ Saturday, July 15, 2006 2:47 PM | Feedback (0)

How to get SQL Server 2005 Diagrams to work

posted @ Saturday, July 15, 2006 2:43 PM | Feedback (0)