SQL Server 2005 XML support

Next >>

What are the major improvements in SQL Server 2005 for XML supports?

With SQL Server 2005 there are six major improvements for XML support: XML DML (XML Data Modification Language)....................
Read answer

What is XQuery? Discuss about XQuery structure.

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 concepts and capabilities of FOR XML in SQL Server 2005.

SQL Server 2000 provides the facility to retrieve data in the form of XML with the help of the FOR XML clause appended to the end of a SELECT statement.............
Read answer

Explain the purpose of PATH mode of FOR XML in SQL Server 2005 with an example.

The PATH mode provides a simpler way to: mix elements and attributes,  introduce additional nesting for representing complex properties...................
Read answer

Explain the following concept of XQuery. Sequence, Atomization, Quantification,
Type promotion

Sequence A sequence can be constructed by using the comma operator, which evaluates each of its operands and concatenates the resulting sequences into a single sequence...............
Read answer

What is Untyped XML?

In untyped xml data type you do not have a schema for your XML data. Although the schemas exist, they may not be validated on the server side...............
Read answer

Next >>

What is XML?

Answer - XML, Extensible Markup Language, is an open, text based markup language that provides structural and semantic information to data...............

What is XPath?

XPath is a language for addressing an XML document's elements and attributes. As an example, say you receive an XML document that contains the details of a shipment and you want to retrieve the element/attribute values from the XML document.........

List the rules to be followed by an XML document.

Answer - They must have a root tag, the document should be well formed : the tags should be properly closed, since XML is case sensitive, one should take care..............

Define DTD (Document Type definition).

Answer - XML DTD is a rule book that an XML document follows. Once DTD is ready, you can create number of XML documents following the same rules..............

SQL Server Reporting Services

What can SQL Server Reporting Services do?
Explain the architecture of reporting services.
Describe Reporting Lifecycle.
What are the ways to tune Reporting Services?
How to schedule SSAS Database backup.
How to Generate an Auto Incremental Number in a SSIS Package?
Lookup's are a key component in SQL Server Integration Services (SSIS). Explain its purpose
How to unzip a File in SSIS?...........