Saving DataView as XML

[unprsandeep]

Hi All.

I need to save data coming out database in XML format. However the number of files will depend on record count / maximum allowed in one file.

I know the way to restrict dataview to contain the records i want but not sure how i should save the data in XML format.

Any help will be appreciated.

Sandeep.

 

[SgtPeppa]

What Database are you using and what mechanisms do you use to extract the data?

For example in a Stored Procedure in SQL-Server you could have your data returned automatically as Xml Document using

for xml auto

statement!


HTH,

Stephan

 

[unprsandeep]

I am using MS SQL 7.0 and i am not sure if it supports the xml auto statement.