| Error |
Severity |
Description |
| 6800 |
16 |
FOR XML AUTO requires at least one table
for generating XML tags. Use FOR XML RAW or add a FROM clause with a table name. |
| 6801 |
16 |
FOR XML EXPLICIT requires at least three
columns, including the tag column, the parent column, and at least one data
column. |
| 6802 |
16 |
FOR XML EXPLICIT query contains the invalid
column name '%.*ls'. Use the TAGNAME!TAGID!ATTRIBUTENAME[!..] format where TAGID
is a positive integer. |
| 6803 |
16 |
FOR XML EXPLICIT requires the first column
to hold positive integers that represent XML tag IDs. |
| 6804 |
16 |
FOR XML EXPLICIT requires the second column
to hold NULL or nonnegative integers that represent XML parent tag IDs. |
| 6805 |
16 |
FOR XML EXPLICIT stack overflow occurred.
Circular parent tag relationships are not allowed. |
| 6806 |
16 |
Undeclared tag ID %d is used in a FOR XML
EXPLICIT query. |
| 6807 |
16 |
Undeclared parent tag ID %d is used in a
FOR XML EXPLICIT query. |
| 6808 |
16 |
XML tag ID %d could not be added. The
server memory resources may be low. |
| 6809 |
16 |
Unnamed column or table names cannot be
used as XML identifiers. Name unnamed columns using AS in the SELECT statement. |
| 6810 |
16 |
Column name '%.*ls' is repeated. The same
attribute cannot be generated more than once on the same XML tag. |
| 6811 |
16 |
FOR XML is incompatible with COMPUTE
expressions. Remove the COMPUTE expression. |
| 6812 |
16 |
XML tag ID %d that was originally declared
as '%.*ls' is being redeclared as '%.*ls'. |
| 6813 |
16 |
FOR XML EXPLICIT cannot combine multiple
occurrences of ID, IDREF, IDREFS, NMTOKEN, and/or NMTOKENS in column name
'%.*ls'. |
| 6814 |
16 |
In the FOR XML EXPLICIT clause, ID, IDREF,
IDREFS, NMTOKEN, and NMTOKENS require attribute names in '%.*ls'. |
| 6815 |
16 |
In the FOR XML EXPLICIT clause, ID, IDREF,
IDREFS, NMTOKEN, and NMTOKENS attributes cannot be hidden in '%.*ls'. |
| 6816 |
16 |
In the FOR XML EXPLICIT clause, ID, IDREF,
IDREFS, NMTOKEN, and NMTOKENS attributes cannot be generated as CDATA, XML, or
XMLTEXT in '%.*ls'. |
| 6817 |
16 |
FOR XML EXPLICIT cannot combine multiple
occurrences of ELEMENT, XML, XMLTEXT, and CDATA in column name '%.*ls'. |
| 6818 |
16 |
In the FOR XML EXPLICIT clause, CDATA
attributes must be unnamed in '%.*ls'. |
| 6819 |
16 |
The FOR XML clause is not allowed in a %ls
statement. |
| 6820 |
16 |
FOR XML EXPLICIT requires column %d to be
named '%ls' instead of '%.*ls'. |
| 6821 |
16 |
GROUP BY and aggregate functions are
currently not supported with FOR XML AUTO. |
| 6824 |
16 |
In the FOR XML EXPLICIT clause, mode
'%.*ls' in a column name is invalid. |
| 6825 |
16 |
ELEMENTS mode requires FOR XML AUTO. |
| 6826 |
16 |
Every IDREFS or NMTOKENS column in a FOR
XML EXPLICIT query must appear in a separate SELECT clause, and the instances
must be ordered directly after the element to which they belong. |
| 6827 |
16 |
FOR XML EXPLICIT queries allow only one
XMLTEXT column per tag. Column '%.*ls' declares another XMLTEXT column that is
not permitted. |
| 6828 |
16 |
XMLTEXT column '%.*ls' must be of a string
data type. |
| 6829 |
16 |
FOR XML EXPLICIT and RAW modes currently do
not support addressing binary data as URLs in column '%.*ls'. Remove the column,
or use the BINARY BASE64 mode, or create the URL directly using the
'dbobject/TABLE[@PK1="V1"]/@COLUMN' syntax. |
| 6830 |
16 |
FOR XML AUTO could not find the table
owning the following column '%.*ls' to create a URL address for it. Remove the
column, or use the BINARY BASE64 mode, or create the URL directly using the
'dbobject/TABLE[@PK1="V1"]/@COLUMN' syntax. |
| 6831 |
16 |
FOR XML AUTO requires primary keys to
create references for '%.*ls'. Select primary keys, or use BINARY BASE64 to
obtain binary data in encoded form if no primary keys exist. |
| 6832 |
16 |
FOR XML AUTO cannot generate a URL address
for binary data if a primary key is also binary. |
| 6833 |
16 |
Parent tag ID %d is not among the open
tags. FOR XML EXPLICIT requires parent tags to be opened first. Check the
ordering of the result set. |
| 6834 |
16 |
XMLTEXT field '%.*ls' contains an invalid
XML document. Check the root tag and its attributes. |
| 6835 |
16 |
FOR XML EXPLICIT field '%.*ls' can specify
the directive HIDE only once. |
| 6836 |
16 |
FOR XML EXPLICIT requires attribute-centric
IDREFS or NMTOKENS field '%.*ls' to precede element-centric IDREFS/NMTOKEN
fields. |
| 6837 |
16 |
The XMLTEXT document attribute that starts
with '%.*ls' is too long. Maximum length is %d. |
| 6838 |
16 |
Attribute-centric IDREFS or NMTOKENS field
not supported on tags having element-centric field '%.*ls' of type TEXT/NTEXT or
IMAGE. Either specify ELEMENT on IDREFS/NMTOKENS field or remove the ELEMENT
directive. |
| 6839 |
16 |
FOR XML EXPLICIT does not support XMLTEXT
field on tag '%.*ls' that has IDREFS or NMTOKENS fields. |
| 6840 |
16 |
XMLDATA does not support namespace elements
or attributes such as '%.*ls'. Run the SELECT FOR XML statement without XMLDATA
or remove the namespace prefix declaration. |
| 7000 |
16 |
OPENXML document handle parameter must be of data type int. |