27
2007-06

SQL Server 2008의 7가지 새로운 datatype

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

via SQL Server 2008 Will Have 7 New Datatypes

date와 time을 드뎌(?) 제공하는군요 =_=;

SQL Server 2008 CTP 다운로드

2 Comments + Add Comment

  • 음.. 기대했던 unsigned smallint, int 는 제공하지 않는군요..

  • 네 기존하던데로 check 함수로 제약사항을 만들어야되네요…

Leave a comment