1
Vote

FROM OPENXML syntax not corrected/detected

description

the following syntax are not detected/corrected
INSERT into #tempTable
SELECT c1, c2 , ModifiedDataValue = NULL,  0
FROM OPENXML(@xmlDoc, ''DataValues/DataValue'', 2)
WITH DataValue
and generate error : Error #: 40526 -- 'OPENXML' rowset provider not supported in this version of SQL Server.

comments