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

By Bill Graziano on 22 December 2003 | Tags: SQL Server 2005


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.

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


Related Articles

Handling SQL Server Errors (5 April 2010)

Microsoft Releases Updated SQL Server 2005 SP2 (6 March 2007)

SQL Server 2005 SP2 Available (19 February 2007)

SQL Server 2005 Service Pack 2 CTP is Available (8 November 2006)

SQL Server 2005 SP1 (19 April 2006)

SQL Server 2005 RTM Code Available (27 October 2005)

SQL Server 2005 Release Date - November 7th, 2005 (7 June 2005)

April CTP (aka Beta 3) Available Today (18 April 2005)

Other Recent Forum Posts

T-sql - we created Message from app1 and trying to disable from app2 (108m)

SQL select Top 10 records for unique combination of two columns (15h)

SSRS Report Sorting with Grouping Issue (1d)

ORA-01476: divisor is equal to zero (1d)

Create new columns based on min and max values of a record with multiple rows (1d)

Memory Required for Reporting Services 2022 (1d)

Backup sql server large db on cloud (2d)

Selecting x columns but only displaying y columns (2d)

- Advertisement -