Export (0) Print
Expand All

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft