\nAnd now, for something a little technically lighter… I've taken to using a convention when writing statements that involve XML\/XQuery and SQL together. I put the XML input or XQuery program on separate lines than the SQL part of the statement, this seems to make both query languages and also inline XML data easier to read when they're in the same statement. Like this:\n<\/p>\n
\n— SQL part
\nSELECT invoice.query('
\n{– XQuery part, smiley face comments still unsupported –}
\ndeclare namespace inv = "urn:www-develop-com:invoices";
\nfor $i in \/inv:Invoice
\nreturn <foo><\/foo>
\n{– more SQL follows –}
\n')
\nFROM invoices\n<\/p>\n
\nI don't necessarily use the XQuery comments at the end (or at the beginning either), but you get the gist. If you adapt this convention, don't EVER try this:\n<\/p>\n
\nINSERT INTO xmltable VALUES('
\n<?xml version="1.0" encoding="UTF-8"?>
\n<doc><\/doc>
\n')\n<\/p>\n
\nLooks like a variation of the first example, but it won't work. The ?xml declaration (it's not a processing instruction) must be *exactly* the first characters in an XML document if used (its optional). The parser uses the first few characters in the declaration, if you use it, to identify the XML document, realizing that the declaration also specifies the document encoding. "Pretty formatting" XML in the example above produces a carriage return-line feed followed by XML declaration, which is forbidden. Error is:\n<\/p>\n
\nMsg 9438, Level 16, State 1, Line 1
\nXML parsing: line 2, character 6, text\/xmldecl not at the beginning of input\n<\/p>\n
\nEither this:\n<\/p>\n
\nINSERT INTO xmltable VALUES('<?xml version="1.0" encoding="UTF-8"?>
\n<doc><\/doc>
\n')\n<\/p>\n
\nor leaving the declaration out if possible:\n<\/p>\n
\nINSERT INTO xmltable VALUES('
\n<doc><\/doc>
\n')\n<\/p>\n
\nwill work fine.\n<\/p>\n
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
And now, for something a little technically lighter… I've taken to using a convention when writing statements that involve XML\/XQuery and SQL together. I put the XML input or XQuery program on separate lines than the SQL part of the statement, this seems to make both query languages and also inline XML data easier to read when they're […]<\/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-1005","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sql-server-xml"],"yoast_head":"\n