Querying and modifying XML data in SQL Server 2005

Next >>

What is XQuery language?

XQuery is a way to query the XML data, It is built on XPath expressions and is supported by quite a few database engines...............
Read answer

Explain the syntax rule of XQuery language.

XQuery is written in FLWOR fashion which stands for: For, Let, Where, Order by, Return.............
Read answer

XQuery expression contains two parts: the Prolog and the Body. Explain them

An XQuery query is made up of a prolog and a body. The XQuery body comprises of a sequence of expressions that specify the intended query result..............
Read answer

Explain PATH expression in XQuery with an example.

Next >>

What is XMLA ?

Answer - It is a Microsoft specified XML-messaging-based protocol for exchanging analytical data between client applications and servers..............

What is DOM?

Answer - DOM is an interface-oriented Application Programming Interface. It allows for navigation of the entire document...............

What is XML Namespace?

Answer - An XSL sheet or a document may have duplicate elements and attributes. Therefore, the XML namespaces define a way to distinguish between..............

Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?..........

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................

What is XPath?

XPath is a language defined by the W3C, used to select nodes from XML documents.................