Prior to SQL Server 2008 , SQL developers were restricted to using two types to work with date and time values: datetime and smalldatetime . While they are sufficient in most user scenarios, there are some limitations: 1) Both types include both the...