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.