What is FOR XML clause in SQL?

 Posted by Virendradugar on 12/5/2009 | Category: Sql Server Interview questions | Views: 5628
Answer:

FOR XML Clause is used with SQL Server’s Select statement to convert the relational data stored in your database to XML.

It has two options
1. Raw: To display XML element for each row.
2. Auto : It will automatically parse the structure used in query


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Easwaran on: 8/31/2012 | Points: 10
What about Explicit option?

Login to post response