.png)
Setting Options (XML Data Type)
SQL Server 2008
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.
