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.
See Also
Concepts
SET Options That Affect Results
Sample XML Applications
xml Data Type