Search
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Articles Author
Sat, 28-Feb-2015 Authors
All Time Authors
vishalneeraj-24503
49160
Rajkatie
21960
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)
 Interview Question

How to return XML in SQL Server?

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

Answer:

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 http://www.sqljunkies.ddj.com/Article/296D1B56-8BDD-4236-808F-E62CC1908C4E.scuk


Asked In: Many Interviews | Alert Moderator 

Share this to:

Bookmark It

Comments or Responses

Posted by: manikandanpszsl-20650 on: 2/8/2013 | Points: 10

wow... nice question...

Login to post response