XML code using sql server 2000

programming
1

Hi,

I would like to write a XML code to retrive the data from sql server 2000 in the following format…

<DATABASECHANGES DBTYPE=“SQLSERVER” APPTYPE=“RAJAPP” VERSION=“1”>

  • <SCRIPT>
  • <![CDATA[
    CREATE TABLE SAMPLE
    (
    SAMPLE_ID NUMERIC NOT NULL,
    TEXT NVARCHAR(20) NULL,
    CONDENSE_WITH NVARCHAR(30) NULL,
    );

]]>
</SCRIPT>
</DATABASECHANGES>

Please help very urgent also let me know any URL giving samples for the above.

Thanks & Regards

Raj.