Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
When you create an XML index on the xml type column or when rebuilding an XML index, 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, you will not be able to create an XML index. Also, you will not be able to insert or modify XML values in an XML column on which an XML index has been created.
See Also
Concepts
SET Options That Affect Results
Sample XML Applications