LOS ANGELES — Microsoft at its Professional Developers Conference 2003 here on Tuesday will discuss intentions to add an XML data type to its SQL Server database, with the Yukon release of the ...

Note the following general limitations that apply to the xml data type: The stored representation of xml data type instances can't exceed 2 GB. It can't be used as a subtype of a sql_variant instance.

It's called 'XML', and it lets you store the XML data into a field that is of this type. Let's see what all you can do with having XML in your database tables. Since XML is now a full-fledged datatype ...

SQL Server does not yet support an XML data type or the SQL/XML extensions, but Tom Rizzo, SQL Server group product manager at Redmond, Wash.-based Microsoft, says that Yukon, due in 2004, will ...

This became even easier in SQL Server 2005 with the advent of the XML data type and XQuery. You still need to construct and shred the XML data before you can use it; this is functional but not simple.

Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL. Stored ...