Updating db from xml
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.The declaration specifies which XML version is being used and can optionally include encoding information.In this case, the declaration indicates that the data is stored as a sequence of 8-bit Unicode characters.This is because SQL Server supports XML documents and XML fragments, both of which are considered XML instances.Although you’ll often see the terms XML instance and XML document used interchangeable, strictly speaking, they are different, with a document being a type of instance, as is a fragment.
It uses tags to describe the nature of the data and how the data should be formatted.
Its universal acceptance and standardized methodology make it a simple yet effective way to move data between applications that serve different functions and are based on different technologies.
You’ll often find that SQL Server documentation refers to the XML stored in an xml object (column, variable, or parameter) as an XML instance.
Rob Sheldon, in contrast, can answer even those questions we somehow feel silly asking in public, and think twice about doing so.
In some cases, the file system might be fine, if you don’t plan to associate the files with any data in your SQL Server database and you don’t want to take advantage of any of the XML-specific features that SQL Server provides, such as being able to associate relational data with data in an XML instance.
Take a look at how you plan to access and modify your XML files, and then decide.