Post reply

xml type in sql server 2000

  • June 12, 2009 at 2:27 am

    #222453

    Do we have an xml type in sql server 2000?

    Or if it is included in any of the service pack.?

    Thanks,

    Raj

  • June 12, 2009 at 2:33 am

    #1008439

    draj108 (6/12/2009)

    Do we have an xml type in sql server 2000?

    Or if it is included in any of the service pack.?

    Thanks,

    Raj

    No, not in SQL 2000. You can store xml data into a text column but you cannot use xquery to query the document.

    [font="Verdana"]Markus Bohse[/font]

  • June 12, 2009 at 2:48 am

    #1008442

    Thanks Bhose... Is there any way to find a particular element value. lets say i have a country elements in an xml doc.

    ex:

    India

    Australia

    ...........

    Can you suggest........ actually i want to find the value and replace it with the correct one.

    Thanks,

    Raj

  • June 13, 2009 at 8:23 am

    #1009077

    Have a look to BOL for "sp_xml_preparedocument" and "sp_xml_removedocument".

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

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