9532

Product

Name

Event ID

9532

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

XMLERR_COLUMNSET_CANNOT_CONVERT_FROM_TO

Message

Text

In the query/DML operation involving column set ’%.*ls’, conversion failed when

converting from the data type ‘%ls’ to the data type ‘%ls’ for the column ’%.*ls’.

A column set is an untyped XML representation that combines some of the columns of a table

into a structured output. When you are inserting or updating sparse column values through the

XML column set, the values that are inserted into the underlying sparse columns are implicitly

converted from the

data type. A value was provided that cannot be converted to the data

type of the column.

Because the value provided could not be implicitly converted, it might be an invalid entry.

Correct the error and retry. If the value is correct, modify the statement to use the individual

columns instead of the column set. This will allow you to explicitly cast the value into the

correct data type.

ﾉ

Expand table