Setting Options (XML Data Type)

When querying xml type columns or variables using xml data type methods, the following options must be set as shown.

SET Options

Required Values

ANSI_NULLS

ON

ANSI_PADDING

ON

ANSI_WARNINGS

ON

ARITHABORT

ON

CONCAT_NULL_YIELDS_NULL

ON

NUMERIC_ROUNDABORT

OFF

QUOTED_IDENTIFIER

ON

If the options are not set as shown, queries and modifications on xml data type methods will fail.