New Data types Introduce in SQL Server 2008

Question

Hi What are the new Data types introduce in SQL Server 2008 ?

Satyapriya Nayak · Answer

Hi Arun SQL Server 2008's new data types: Date and Time : Four new date and time data types have been added making working with time much easier than it ever has in the past. They include: DATE  TIME  DATETIME2  and DATETIMEOFFSET . Spatial : Two new spatial data types have been added-- GEOMETRY and GEOGRAPHY --which you can use to natively store and manipulate location-based information such as Global Positioning System (GPS) data. HIERARCHYID : The HIERARCHYID data type is used to enable database applications to model hierarchical tree structures such as the organization chart of a business. FILESTREAM : FILESTREAM is not a data type as such but is a variation of the VARBINARY(MAX) data type that allows unstructured data to be stored in the file system instead of inside the SQL Server database. Because this option requires a lot of involvement from both the DBA administration and development side I will spend more time on this topic than the rest. Please refer the below link http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/ Thanks