Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Process for populating an existing xsd Expand / Collapse
Author
Message
Posted Tuesday, April 14, 2009 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 15, 2012 9:21 AM
Points: 2, Visits: 63
Could someone suggest a simple process for the following?

1) Import an existing xsd as a SQL schema
2) Populate that schema with a select from a table
3) Write out the resulting xml document to a file

The options I've considered are overly complicated I believe:

1) Create XML Schema Collection
2) Select For XML (can't see how it would map the returned columns to the XML elements of the schema)
3) Use XML DM insert to insert the returned columns into explicit elements in the schema (why use the schema then?).


All help is appreciated!



Post #696691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse