# XML code using sql server 2000

**URL:** <https://forum.kirupa.com/t/xml-code-using-sql-server-2000/242387>\
**Category:** programming\
**Created:** [October 25, 2007, 12:26pm UTC](https://forum.kirupa.com/t/xml-code-using-sql-server-2000/242387 "2007-10-25T12:26:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![krajdba](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@krajdba](https://forum.kirupa.com/u/krajdba)\
**Post date:** [October 25, 2007, 12:26pm UTC](https://forum.kirupa.com/t/xml-code-using-sql-server-2000/242387/1 "2007-10-25T12:26:17Z")

</div>

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.