Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

AUTO Mode Enhancements

SQL Server 2005

AUTO mode determines the shape of returned XML, based on the query. In determining how elements are to be nested, AUTO mode heuristics compare column values in adjacent rows.

In SQL Server 2000, the columns of all types, except ntext, text, and image, were compared. In SQL Server 2005, columns of xml type are also not compared, but columns of type (n)varchar(max) and varbinary(max) are compared. Also, for SQL Server 2005, derived table support has been improved so that it can be used to group under the same element columns from different tables, but hide the join from AUTO mode heuristics.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft