FIX: ‘There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()’ error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

When you run an XQuery query to update the value of an XML column in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 , the XQuery query does not run. Additionally, you receive an error message that resembles the following:

Read More - Register for Free Membership