Necessary SET options while querying XML Data Types

By Santhosh N

This explains the necessary SET Options required while working with XML Data types.

These SET Options should be set to ON: ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER


And, this SET Option should be set to OFF: NUMERIC_ROUNDABORT

Related FAQs

This explains difference between typed and untyped XML Type in Sql Server.
This explains how to create secondary XML indexes and different types of Secondary indexes that can be created for XML Data types in SQL Server
This explains about the limitations of the XML Data type in Sql Server in terms of creating Index
Necessary SET options while querying XML Data Types  (723 Views)