O'Reilly logo

Pro T-SQL 2008 Programmer's Guide by Michael Coles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. T-SQL 2008 New Features

Every new version of SQL Server comes with several new T-SQL features and enhancements. SQL Server 2008 is no exception. In the newest version of SQL Server, Microsoft has responded to developer requests in a big way. SQL Server 2008 supports brand new developer convenience features like single-statement variable declaration and initialization, new data types to manipulate and query date-based and spatial data, new statements like MERGE that add much-needed functionality to T-SQL, and a whole lot more.

When moving from SQL Server 2000, there will be a slight learning curve, although the basics of T-SQL will still be familiar. SQL Server 2005 developers, on the other hand, will feel right at home when developing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required