SQL Server design

6/5/2014·1 min read
  • DATETIME vs DATETIME2
    • SQL Server DATETIME supports 1753/1/1 to "eternity" (9999/12/31), so if application pass default type Datetime, which is 0001-01-01, it'll throw exception from database. DATETIME2 support 0001-01-01.