Here's some of the new enhancements to T-SQL for 2008 (from http://technet.microsoft.com/en-us/library/cc721270.aspx). I don't really know how any of it works yet, or what specifically would be important to add, but this is a start, at least.
The HierarchyID data type looks interesting... it's apparently an optimization for hierarchical data querying, etc. New Date and Time types store just the Date part and the Time part, instead of forcing both into a DateTime field. · Declaring and initializing variables · Compound assignment operators · Table value constructor support through the VALUES clause · Enhancements to the CONVERT function · New date and time data types and functions · Large UDTs · The HIERARCHYID data type · Table types and table-valued parameters · The MERGE statement, grouping sets enhancements · DDL trigger enhancements · Sparse columns · Filtered indexes · Large CLR user-defined aggregates · Multi-input CLR user-defined aggregates · The ORDER option for CLR table-valued functions · Object dependencies · Change data capture · Collation alignment with Microsoft Windows · Deprecation --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
