I am trying to insert a value to sql_variant column in sql server from an xml column
ex.
INSERT INTO
[dbo].[TestColumn]
(
Id,
Attribute,
AttributeValue
)
SELECT
Id,
'TestName',
CAST(CustomColumns.query('//TestName') AS nVarchar(MAX))
FROM
[dbo].[Clmnt] (NOLOCK)
I got this error,
Operand type clash: nvarchar(max) is incompatible with sql_variant
Anybody has any clue on this, How do I easily insert a value in sql_variant?