Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Display the table data in xml format

Author  Topic 

vinnakanna58
Starting Member

5 Posts

Posted - 2009-04-30 : 00:31:30
i have a table in database. i want to display the particular table data into XML format by calling stored procedure.

so tel how its possible

vinay kumar k

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-07 : 02:06:16
Use the FOR XML AUTO statement.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -