SQL Server Error Msg 6315 – XQuery: Cannot update with value ‘%.*ls’ as the canonical form of type ‘{%.*ls}%.*ls’ violates the required pattern. It is recommended that you not use pattern facets on non-string types.

In this blog post, let’s learn about the error message “6315 – XQuery: Cannot update with value ‘%.*ls’ as the canonical form of type ‘{%.*ls}%.*ls’ violates the required pattern. It is recommended that you not use pattern facets on non-string types.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

6315 – XQuery: Cannot update with value ‘%.*ls’ as the canonical form of type ‘{%.*ls}%.*ls’ violates the required pattern. It is recommended that you not use pattern facets on non-string types.

Reason for the Error

To be update soon…

Solution

To be update soon…