XML Rookie Needing Assistance

• jG

  SSCrazy

  Points: 2505

  More actions

  May 4, 2004 at 1:54 pm

  #76155

   I am new to using XML. A Vendore has provided us a SCHEMA file, and are asking that we export our data out of a database using there Scheama. Ok here is the question.

  Where do I start?

  Thanks -jG

  
  -JG

• Peter Evans

  Ten Centuries

  Points: 1187

  More actions

  May 4, 2004 at 6:50 pm

  #505223

  Check out the T-SQL FOR XML clause in BOL.  Also, check out the SQLXML stuff for creating XSD XML views.

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/ssxsdannotations_0gqb.asp

  Peter Evans (__PETER Peter_)