Updating db from xml a2zdating com
In addition, storing your XML in a SQL Server database lets you take advantage of SQL Server’s administrative capabilities and data access mechanisms, such as OLE DB and ADO. Even if you don’t store data in an xml column, you can still leverage the other SQL Server storage and access capabilities.
That said, if you don’t need any of these features, you might not need SQL Server.
This basic example also points out the hierarchical nature of XML and its self-describing nature.
We could have just as easily created an XML structure that describes people, places, or other things.
By storing the document within the database, you can create queries that retrieve both relational data and specific information within the XML instance related to that data.
To make things worse, XML experts generally lack the wherewithal to provide simple answers to even the simplest questions.
The data type supports several methods that let you query and modify individual elements, attributes, and their values directly within the XML instance, rather than having to work with that instance as a whole.
In addition, the xml data type ensures that each XML instance is, at the very least, well formed according to ISO standards.
As the name suggests, XML is a text-based language similar to HTML.
It uses tags to describe the nature of the data and how the data should be formatted.