Script to Get Total Rows, space used and reserved (KB) of all tables
2006-08-18 (first published: 2006-08-01)
1,079 reads
Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]
2006-08-21 (first published: 2006-08-01)
469 reads
Encrypting a DTSRUN command in T-SQL
2009-03-11 (first published: 2006-08-01)
763 reads