XML

• AER

  SSCrazy

  Points: 2763

  More actions

  December 3, 2001 at 4:29 pm

  #104585

  Can I use XML in SQL Server 7.0?

  And what do I need for that?

  I found example on the Internet and they tell you that this code should work for SQL Server 7.0 for Pub database, but it doesn't:

  SELECT store.stor_id as Id, stor_name as Name, sale.ord_num as OrderNo,

  sale.qty as Qty

  FROM stores store inner join sales sale on store.stor_id = sale.stor_id

  ORDER BY stor_name

  FOR XML RAW

  May be I need to install XML Parser; register dll's or anything else...

  I would appreciate any help.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  December 3, 2001 at 9:01 pm

  #420664

  For xml was added in SQL2K. I know there was a web release that added some xml functionality to SQL7 but honestly have not looked - that might be a good starting place.

  Andy

  Andy
  Connect with me on LinkedIn