Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    Dubai
    Posts
    29

    Lightbulb Unanswered: XML read and write

    Pls help guys

    I need to know whether its possible to read or write in to XML documents from SQLServer directly using stored procedures.

    I basically need to created a number of XML documents on a nightly basis.,..........also i need to read a no of XML docs to SQLServer...

    Is it wise to use stored procedures for this?
    Or are there performance issues.........and do u suggest doing in in .NET


    Your comments are appreciated..

    Regards

    Benny

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Yes you can
    [BOL] Retrieving and Writing XML Data

    and try
    This Link
    Last edited by Ruprect; 04-04-04 at 13:32.

  3. #3
    Join Date
    Mar 2004
    Location
    Dubai
    Posts
    29
    Hi..
    Thanks....BUT that doesnt explain how to write to the XML file in a directory...or read from an XML file..

    Pls respond abt that ..

    Thanks!

    Originally posted by Ruprect
    Yes you can
    [BOL] Retrieving and Writing XML Data

    and try
    This Link

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    sorry
    i had a brain fart
    i am working on it

  5. #5
    Join Date
    Mar 2004
    Location
    Dubai
    Posts
    29

    Red face

    Hi all,
    Im still struggling on this, please help me out.

    Do you know any method to read xml from a file in SQLServer and write XML to the file system in SQLServer.

    Everywhere i can see OPENSQL, etc but they talk of just the XML in string format.

    Please help!

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You will need to use sp_xml_preparedocument to prepare the document for use by SQL Server.

    You can then open up the file with the OPENXML syntax. You should be able to find all this in Books online by typeing in OPENXML.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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