7 New DataTypes for SQL Server 2008

For a database administrator , please aware that SQL Server 2008 will now have new datatypes as below are the list.

DATE – ANSI-compliant date data type
TIME – ANSI-compliant time data type with variable precision
DATETIMEOFFSET – timezone aware/preserved datetime
DATETIME2 – like DATETIME, but with variable precision and large date range
GEOMETRY – “flat earth” spatial data type
GEOGRAPHY – “round earth” spatial data type
HIERARCHYID – represents hierarchies using path enumeration model

The first four datatypes are regular SQL datatypes but the last three datatypes are exposed as .NET system UDTs.

Published by

Mick Genie

Mick Genie is the founder of MickGenie.com and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information.