Error Message:
Msg 402, Level 16, State 1, Line 5
The data types varchar(max) and xml are incompatible in the add operator.
This message occurs when you try to add varchar and xml data types.
Fix:
If you wanted to concatinate the XML Data type and Varchar Data type values, use the CAST Operator on XML Data type to convert into VARCHAR Datatype.
Example:
[sql]
DECLARE @a XML
DECLARE @b VARCHAR(max)
SET @a = ‘<A></A>’
SET @b = ‘ABC’
SELECT @b + @a
[/sql]
The Above code Gives Error 402.
Fixed Code:
[sql]
DECLARE @a XML
DECLARE @b VARCHAR(max)
SET @a = ‘<A></A>’
SET @b = ‘ABC’
SELECT CAST(@a AS VARCHAR(max))+@b
[/sql]