FOR XML in SQL Server 2005

          

FOR XML in SQL Server 2005

Next >>
Discuss the TYPE directive of FOR XML with an example.

SQL Server 2000 always returns the result of a FOR XML query directly to the client in textual form. SQL Server 2005 enables you to optionally request that the result of a FOR XML query be returned as xml data type by specifying the TYPE directive..............
Read answer

Explain the RAW mode of FOR XML with an example.

Each row in the query result is transformed into an XML element that has the generic identifier <ROW> or the optionally provided element name in RAW mode...............
Read answer

Explain the AUTO mode of FOR XML with an example.

AUTO mode returns query results as nested XML elements. This does not provide much control over the shape of the XML generated from a query result.............
Read answer

Explain the EXPLICIT mode of FOR XML with an example.

Using EXPLICIT Mode provides more control and flexibility in deciding the shape of the XML from a query result..............
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 XSL?

Answer - XSL is a language for expressing style sheets. An XSL style sheet is a file that describes the way to display an XML 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..............

Querying and modifying XML data in SQL Server 2005

What is XQuery language?
Explain the syntax rule of XQuery language.
XQuery expression contains two parts: the Prolog and the Body. Explain them
Explain PATH expression in XQuery with an example................

XML Schemas in SQL Server 2005

Syntax and example for creating and dropping XML schema collection.
Limitations of the XML Schema collections.
Discuss about XML schema collection permission............



Write your comment - Share Knowledge and Experience


 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring