Describe the XML support SQL server
extends.
Sql server - XML support SQL server
extends - Feb 08, 2010 at 17:10 PM by Shuchi Gauri
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
Describe the XML support SQL server extends.
Answer
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.
Also read
Answer - Master database is
system database. It contains information about server’s
configuration. It is a very important database and important to
backup Master.....
Answer - Distributed Query is a query which can retrieve data from
multiple data sources including distributed
data........
Answer - SQL Server uses different ways to
execute SQL statements which are listed below......
Answer - XPath is a language defined by the W3C,
used to select nodes from XML documents. ....
Answer - CREATE DEFAULT, CREATE PROCEDURE,
CREATE RULE, CREATE TRIGGER, and CREATE VIEW statements....
|
