\nRereading the post about this from last night, it appears that I may have used an ambiguous analogy when attempting to figure why this feature works the way it does, and given folks the wrong idea. It has to do with whether the results of the query would be wrong or the query itself is “incorrect”. Using the invoice example from the previous post:\n<\/p>\n
\n— this SQL query would fail to compile
\nSELECT invoice.query('
\ndeclare namespace inv = "urn:www-develop-com:invoices";
\nfor $i in \/fooelement
\nreturn <foo><\/foo>
\n')
\nFROM invoices\n<\/p>\n
\n— this SQL query would compile, execute,
\n— and produce correct (but not schema-valid) results
\nSELECT invoice.query('
\ndeclare namespace inv = "urn:www-develop-com:invoices";
\nfor $i in \/inv:Invoice
\nreturn <foo><\/foo>
\n')
\nFROM invoices\n<\/p>\n
\nThe reason for this is that the SQL Server “query” method on SQL Server's XML data type always produces *untyped* XML by definition. So the first SQL statement fails because the query itself is wrong, not because the results would be incorrect.\n<\/p>\n
\nIn the analogy to SQL, the statement: “SELECT foo FROM invoices” fails not because there can't be a “foo” column in the output rowset but because selecting foo on the input in invalid. Actually, you can produce a “foo” column in the output:\n<\/p>\n
\nSELECT invoiceid AS foo FROM invoices\n<\/p>\n
\nso perhaps that wasn't such a bad analogy after all.<\/p>\n","protected":false},"excerpt":{"rendered":"
Rereading the post about this from last night, it appears that I may have used an ambiguous analogy when attempting to figure why this feature works the way it does, and given folks the wrong idea. It has to do with whether the results of the query would be wrong or the query itself is “incorrect”. Using […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,37],"tags":[],"class_list":["post-1006","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sql-server-xml"],"yoast_head":"\n