Most RecentMost ViewedMost LikesParsing larger XML file using “sp_OACreate” returns incorrect valuesFirst published on MSDN on Oct 23, 2009 sp_OACreate is a way to instantiate OLE / COM objects inside of SQL Server in the MemToLeave area of the server’s address space, or out of process in dllhost.How to grab multiple parent/child elements from XML Data SourceFirst published on MSDN on Apr 29, 2014 We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data.
