|
Describe the XML support SQL server extends.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.Describe the XML support SQL server extends.SQL server can return XML document using FOR XML clause. XML documents can be added to SQL Server database and you can use the OPENXML clause to display the data from the document as a relational result set. SQL Server 2000 supports XPath queries.
|
