• Resetting the value of an Identity column in T-SQL

DBCC CHECKIDENT (tablename, reseed, 7)  -- When you insert a row, the Identity column will have a value of 8.

SELECT CONVERT(DATETIME, CONVERT(CHAR(8), 20070824))