Concepts and capabilities of FOR XML in SQL Server 2005

          

Concepts and capabilities of FOR XML in SQL Server 2005

<<Previous   Next>>

Explain the concepts and capabilities of FOR XML in SQL Server 2005 - March 04, 2009 at 18:00 PM by Amit Satpute

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.

There are 3 types of FOR XML modes — RAW, AUTO, and EXPLICIT.

They all generate a different style of XML document.

Capabilities of FOR XML in SQL Server 2005:

  • The new XML datatype in SQL 2005, and the new associated methods (query, exists, value, and nodes)
  • A reusable T-SQL UDF to convert XML to a table variable
  • New SELECT FOR….XML capabilities
  • Performing partial text searches inside an XML DataColumn 

<<Previous   Next>>
 



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