SQL Server 2008 Will Have 7 New Datatypes

[SQLDenis]

SQL Server 2008 New Datatypes

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
GEOGRPAHY - "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.

Note: none of these are in the current June CTP ;-(



Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLSister]

did they really intend to misspell geography?

Questions about posting. See faq183-874

 

[SQLDenis]

That should probably be GEOGRAPHY

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLSister]

One of our tables has a field named geography_code and we daily curse whoever orginally used the term because all of us mistype it almost every time. Apparently it's a hard word to type.

Questions about posting. See faq183-874

 

[ESquared]

Typing ability is definitely a skill highly desirable for anyone who wishes to be a programmer or database analyst/developer.

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[LNBruno]

Typing is SO overrated - just use Mr. Microphone...

< M!ke >
Acupuncture Development: a jab well done.

 

[AlexCuse]

Or mr. SQL Prompt :-D

Ignorance of certain subjects is a great part of wisdom

 

[mrdenny]

I'm really hopping that the new data types show up soon. I'm interested to see how they will all be working. I was annoid to see that they were not in the June CTP.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ESquared]

I like the possibility and simplicity of

Convert(date, GetDate())

[COLOR=#aa88aa black]Cum catapultae proscriptae erunt tum soli proscript catapultas habebunt.[/color]

 

[jrbarnett]

Aaargh, I've not yet got around to going live with SQL 2005 on any of my systems and they're talking about superseding it already.
I've still got SQL 7 (and Sybase ASA 5.5) in production use here.

New aim for work: to go live with SQL 2005 on at least one system before SQL 2008 RTM is released.

John

 

[chrissie1]

That's probably because you aren't working nights.

Christiaan Baes
Belgium

"My old site" - Me

 

[AlexCuse]

slacker!

Ignorance of certain subjects is a great part of wisdom