XML Support and SQL Server (Part 4) By Basit A. Farooq Editor’s Note: This article is the fourth part of my XML support and SQL Server article series. In this part, I’ll talk about XML data type. I’ll also demonstrate how you can create XML variables and XML columns, and compare between typed and untyped XML. With the release of...
XML
XML Support and SQL Server (Part 3)
XML Support and SQL Server (Part 3) By Basit A. Farooq This article is the third part of the XML support and SQL Server article series. In this part, I’ll first talk about what fundamental problems we have in integration XML and SQL Server. Then, I’ll cover what storage options we have in SQL Server to store the XML data...
XML Support and SQL Server (Part 2) – XML Schemas
XML Support and SQL Server (Part 2) – XML Schemas By: Basit A. Farooq XML schemas Although, it is possible to create an XML document that follows no formal structure if the document (or fragment) is for internal or your own use. However, this isn’t recommended. Because, as we all know, working without a formal design often leads to a...