GitHub

sql-server-xml-bulk-load-object-model-sqlxml-4-0.md

Learn about the methods and properties of the SQLXMLBulkLoad object that is used for bulk loading XML in SQLXML 4.0. [!INCLUDE SQL Server Azure SQL Database] The Microsoft [!INCLUDEssNoVersion] XML ...
crossjoin.co.uk

The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference

A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I’m ...
GitHub

SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries...

Using Azure SQL Server. MySQL handles it fine, though it is given the same query. I suspect MySQL is just a little less fussy. I have a model that must have a fixed ordering. I set the order on the ...