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.