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))
Be the first to rate this post
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2010
Sign in