Update XML Attibute using SQL Server 2000

• vijaykrishnan-345025

  Grasshopper

  Points: 14

  More actions

  November 26, 2007 at 9:26 pm

  #119634

  Hi all,

  I found in sql server 2005 for updation of xml attributes.Whereas in sql server 2000 there is only provision for parsing the nodes and update the Data in database.Is it possible to parse the xml and update the specified node using sql server 2000 stored procedures or T-SQL

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 27, 2007 at 7:19 am

  #754540

  SQL 2000 doesn't have the xml datatype or xquery support. So you have to translate the data or store it as varchar or text.

  Markus

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

• vijaykrishnan-345025

  Grasshopper

  Points: 14

  More actions

  November 27, 2007 at 9:31 pm

  #754810

  Dear Markus,

  Thanks for ur help.So i can confirm that we have to store it as varchar and do manipulation.

  No updation of xml attributes are supported right.

  Regards,

  Vijay krishnan.R