SQL Server Error Code – 9523 cannot update the sparse column set ‘%.*

In this blog post, you’ll learn more about the SQL Server Error Code 9523 and the error message description that is shown

SQL Server Error Code

9523

SQL Server Error Description for the Code :9523

Cannot update the sparse column set ‘%.*ls’ because the XML content supplied references the non-sparse column ‘%.*ls’ which does not belong to this column set. The XML data used to update a sparse column set cannot reference columns that don’t belong to the column set.