Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


Product Name

SQL Server

Product Version


Product Build Number


Event ID


Event Source




Symbolic Name


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 xml 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft