SQL syntax error: Function call cannot be applied to this expression
Here is my SQL query:
SELECT
CAST(Posts.Body as XML).query('pre/code/text()') AS answerCode
FROM
Posts
WHERE
Posts.Score >= 0 AND
TRY_CAST(Posts.Body AS XML) IS NOT NULL;
And this is error I got:
Syntax error: Function call cannot be applied to this expression. Function calls require a path, e.g. a.b.c() at [2:32]
How can I use this "path" instead of string here?
How many English words
do you know?
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
how many words do you know
Powered by Examplum