\nSQL Server 2008 will contain, if my count is correct, 7 new data types. Note: none of these are in the current CTP.\n<\/p>\n
\nDATE – ANSI-compliant date data type
\nTIME – ANSI-compliant time data type with variable precision
\nDATETIMEOFFSET – timezone aware\/preserved datetime
\nDATETIME2 – like DATETIME, but with variable precision and large date range\n<\/p>\n
\nGEOMETRY – "flat earth" spatial data type
\nGEOGRAPHY – "round earth" spatial data type
\nHIERARCHYID – represents hierarchies using path enumeration model\n<\/p>\n
\nThe first four (date\/time series) are NOT implemented\/exposed as .NET system UDTs, but the last three are exposed as .NET system UDTs. This means that, for the first time, .NET will be used as part of SQL Server. In SQL Server 2005, there were originally DATE and TIME data types implemented in .NET, but implementing temporal data is an intricate process. After much wailing and gnashing of teeth by some members of the user community, these were removed. One of the complaints was the .NET implementation. Hmmm…\n<\/p>\n
\nOne of the nice side-effects of implementing spatial and hierarchyid as .NET types is that these will be shipped as a separate assembly, and that the types will be available for client-side and middle-tier use as well as in the database. So if you want to do some massive number crunching of spatial sequences on a computation server and the network traffic from database to computation server is acceptable, you can do so.\n<\/p>\n
\nIn general, SQLCLR makes the "logic in database or middle-tier" argument easier to deal with. Although there's no "run on database or run on server" switch in VS, with minimal code changes you can move your logic, or even duplicate the logic between tiers if need be. You can't do this with T-SQL; although its faster and better for data access on the database, it doesn't run outside the database. Unless you want to use SQL Server Express Edition as an application server. But that's a discussion for another time.<\/p>\n","protected":false},"excerpt":{"rendered":"
SQL Server 2008 will contain, if my count is correct, 7 new data types. Note: none of these are in the current CTP. 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 […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,38,40],"tags":[],"class_list":["post-788","post","type-post","status-publish","format-standard","hentry","category-sql-server-2008","category-sqlclr","category-transact-sql"],"yoast_head":"\n