XML code using sql server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

XML code using sql server 2000

Author

Topic

krajdba
Starting Member

43 Posts

Posted - 2007-10-24 : 11:02:19

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.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-24 : 11:18:33

you'll need to privide a lot more info than this.

in the meantime here's a starter:
http://www.perfectxml.com/SQLXML.asp

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources