XML and SQL server 2000

• marcopolo56

  SSChasing Mays

  Points: 653

  More actions

  December 19, 2004 at 9:38 am

  #76214

  Anyone who can give good advise in using XML in a SQL server 2000 dB. Microsoft is pumping out there mantra about XML. But is it at all so good to store everything in XML in the dB?

  If I want to make calculations in Store Procedures with dynamic SQL isn't it a overhead storing data in XML?

  I would like a more balanced picture of the XML story. Advantages and disadvantages.

  Anyone with experince or good articles (not Microsoft)

  Regards

• Dave-151643

  SSC Veteran

  Points: 215

  More actions

  December 19, 2004 at 9:19 pm

  #534420

  Not sure how you are working with your xml, but I found this artilce a good starting point:

  http://www.topxml.com/sqlxml/default.asp