Parsing larger XML file using “sp_OACreate” returns incorrect values

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.exe. Whenever you instantiate a COM object using sp_OACreate method you need to destroy the objects  created else it might run out of memory causing the application…

1

Things to know before developing MS XML applications.

XML is a method for putting structured data in a text file . Microsoft XML Core Services (MSXML)  adhere to the XML 1.0 standard. MSXML can be installed both in replace mode and side by side. For example, starting MSXML4 all the versions are installed side by side. Which means that you system might have…

1

How to force System.Xml.Xsl.XslCompiledTransform class to not use self closing tags for empty nodes

In .NET 2.0 framework when you use System.Xml.Xsl.XslCompiledTransform class for transforming a document then we always get self closing tags for all the elements which have nothing inside their body. There is no direct way to ask it to use separate closing tags e.g. <BODY> <TABLE></TABLE> <BR></BR> </BODY> transforms as <BODY> <TABLE/> <BR/> </BODY>  …

0