Post reply

xml schema validation for the sp parameter

  • September 3, 2010 at 1:21 am

    #387722

    Hi all,

    I wanted to validate the parameter string passed to the stored procedure is in proper xml structure..(validate using sql server 2005)...

    Pls help me..

    thanks in advance!!!

    Regards,

    Seetha

  • September 3, 2010 at 5:45 am

    #1216104

    You could cerate an XML Schema collection and use it to make your xml variable a typed variable.

    For details see BOL (BooksOnLine, the SQL Server help system), section "typed XML" and follow the "Typed vs. Untyped XML" link. Example C (Passing an xml type parameter to a stored procedure) should be exactly what you're looking for.


    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]

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

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