Appear in Online Interview to test your skills and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Submit content and win cash & prizes monthly.

Win Prizes

Like us on Facebook
Top Articles Author
Fri, 25-Apr-2014 Authors
All Time Authors
Bharathi Cherukuri

Latest members | More ...

(Statistics delayed by 5 minutes)

How to return XML in SQL Server?

 Posted by Raja on 12/14/2008 | Category: Sql Server Interview questions | Views: 6446

We can use FOR XML statement at the end of the query to return xml data from the SQL Server.

select * from mytable for xml auto

There are three mode of returning XML and they are auto, raw and explicit

For more details see

Asked In: Many Interviews | Alert Moderator 

Found interesting? Add this to:

Comments or Responses

Posted by: Manikandanps@Zsl.Com on: 2/8/2013 | Points: 10

wow... nice question...

Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.