XML

  • 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.

  • 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

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

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