Post reply

xml and sql sp

  • August 26, 2010 at 5:06 am

    #98895

    Hi all,

    can anybody tell me

    how to do crud operation using xml file as a parameter to a stored procedure?

    thanks in advance!!

    seetha

  • August 26, 2010 at 2:16 pm

    #1212551

    You define an XML parameter in your sproc and send your parameter list as a valid xml string.

    In the sproc you transform the xml data into either a relational table or a list of variables.

    Then proceed as needed.

    If you need a more detailed answer please provide a more detailed description of what you're trying to do.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • August 27, 2010 at 4:20 am

    #1212833

    Hi,

    Thanks for ur reply i got a solution for this.. below is the link i referred ..Thanks a lot

    http://www.sqlservercentral.com/articles/Advanced+Querying/queryingxmlfilesusingsql2000/822/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply