Some useful tips for using XML in SQL Server 2019 Consider replacing OPENXML with the XML nodes() function. The nodes() function is useful when you want to shred an xml data type instance into relational data. The result of the nodes() function is a rowset that contains logical copies of the original XML instances. Use CROSS APPLY to get data…