CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. May 4th, 2007, 06:16 AM #1
    bharadwajrv's Avatar
    bharadwajrv
    bharadwajrv is offline Member
    Join Date
    Dec 2001
    Location
    UK
    Posts
    308

    SQL structure to XML schema

    i need to convert my SQL database (on MS SQL 2000) structure to a XML scheme file...

    how to do it??

    Thanks in Adv..
    Cheers..
    Venu
    Venu Bharadwaj
    "Dream it. U can do it!"
    Reply With Quote Reply With Quote
  2. May 4th, 2007, 11:37 PM #2
    George1111
    George1111 is offline Senior Member
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    1,901

    Re: SQL structure to XML schema

    Not sure if this is what you need but it just may be !

    Please let me know if it does what you need as I have not had a chance to test it as yet

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  3. May 4th, 2007, 11:40 PM #3
    TheCPUWizard's Avatar
    TheCPUWizard
    TheCPUWizard is offline Elite Member Power Poster
    Join Date
    Mar 2002
    Location
    St. Petersburg, Florida, USA
    Posts
    12,125

    Re: SQL structure to XML schema

    As shown (dep withing George's sample)

    Code:
    Select * from Table FOR XML AUTO
    is the magic SQL...
    TheCPUWizard is a registered trademark, all rights reserved. (If this post was helpful, please RATE it!)
    2008, 2009,2010
    In theory, there is no difference between theory and practice; in practice there is.

    * Join the fight, refuse to respond to posts that contain code outside of [code] ... [/code] tags. See here for instructions
    * How NOT to post a question here
    * Of course you read this carefully before you posted
    * Need homework help? Read this first
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured