SQL Server 2000 Tricks

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)

SQL Server format dates and times

posted @ Saturday, April 26, 2008 4:59 AM | Feedback (0)

create and myTable_Audit via for myTable, where myTable autoIdentity column name is myTable_ID

posted @ Thursday, March 15, 2007 10:47 AM | Feedback (1)

how to copy text data from one column to another

posted @ Wednesday, February 21, 2007 1:51 PM | Feedback (0)

@userDate match up with @FrequencyCode & @FrequencyValue

posted @ Wednesday, January 31, 2007 10:27 AM | Feedback (0)

SQL Server 2000 Performance Tuning Tools

posted @ Monday, August 07, 2006 5:34 PM | Feedback (0)

Find any datasbase Column by partial Name in any User Table

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