Share via


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.