SQLTeam.com Logo

Return to MSDN: Yukon Basics: XML, T-SQL, and the CLR Create a New World of Database Programming

MSDN: Yukon Basics: XML, T-SQL, and the CLR Create a New World of Database Programming

Written by Bill Graziano on 22 December 2003

The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored procedures, and triggers written in CLR-targeted languages, including Visual Basic .NET and C#. It supports a subset of the W3C standard XQuery language, and has native XML support. In this article, the author outlines the most significant language features and builds an order-entry sample app.