SQL Database Concepts Question:
Explain the XML support SQL server extends?
Answer:
SQL Server (server-side) supports 3 major elements:
a. Creation of XML fragments: This is done from the relational data using FOR XML to the select query.
b. Ability to shred xml data to be stored in the database.
c. Finally, storing the xml data.
Client-side XML support in SQL Server is in the form of SQLXML. It can be described in terms of
XML Views: providing bidirectional mapping between XML schemas and relational tables.
Creation of XML Templates: allows creation of dynamic sections in XML.
a. Creation of XML fragments: This is done from the relational data using FOR XML to the select query.
b. Ability to shred xml data to be stored in the database.
c. Finally, storing the xml data.
Client-side XML support in SQL Server is in the form of SQLXML. It can be described in terms of
XML Views: providing bidirectional mapping between XML schemas and relational tables.
Creation of XML Templates: allows creation of dynamic sections in XML.
| Previous Question | Next Question |
| Do you know what is RANK function? | Tell me what are cursors and when they are useful? |