SQL Server 2008's T-SQL Features

摘要

Besides the obvious benefit of shortening your code, another benefit of using a single statement is that the operation is considered atomic. [...] the current implementation of the enhanced VALUES clause is internally han- dled like this UNION ALL solution- so don't expect any performance improvements. Three small features that you might find handy include the enhanced VALUES clause, improved ISO week number calculation, and the ability to convert character to binary and binary to character values while preserving the hexadecimal digits, Next month I'll cover some additional SQL Server 2008 features that you might find useful.