Check this out: ... FROM @xml.nodes(N'/root/xyz:a') AS A(a); --prefix "dns" would not work, the alias is now "xyz ... And you need the prefix at `root` too!
確定! 回上一頁