Table to xml file

Question

Post reply

Table to xml file

fasttrack

SSCertifiable

Points: 6071
More actions
October 9, 2005 at 8:43 am

#90212

Hi,
Is there a way to trasform a set of data of a table into a xml file?

Thank a lot for any suggestions

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

davidbrown-246109 Grasshopper Points: 12 More actions · Answer 1

look at sp_makewebtask in help. This can create an xml file.

Lisa Twede SSC Enthusiast Points: 176 More actions · Answer 2

At the risk of sounding really dumb, as am very new to XML and somewhat new to SQL Server, I looked up sp_makewebtask in the Help and all it talks about is HTML. What am I missing?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Try these links to get started and also check out more links at the end of the first link. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_759d.asp

http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

Kind regards,

Gift Peddie

Kind regards,
Gift Peddie

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

I am sorry I forgot there is a .NET method ReadXML you can use. Try the link below for the FCL(framework class library) 1.1 ReadXML method, in the link check the side bar for different versions of the method. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatasetclassreadxmltopic2.asp

Kind regards,

Gift Peddie

Kind regards,
Gift Peddie