XML from SQL ?

Last Post 09 Sep 2006 01:05 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

08 Sep 2006 07:11 AM
We have a request to rebuild some sites in XHTML using XSLT and CSS.
The data required to populate the webpages from these sites is stored in an SQL Server 2000 database, and I'm trying to figure out the best way to do this.
Our existing pages are built in ASP.NET (1.1) and are hoping to use our existing business objects.

Can anybody point me in the right direction ?
I'm confused about all the new different ways to do it (web services etc..)

Many thanks
New Member
New Member

09 Sep 2006 01:05 AM
This is the way to export data in XML format from SQL 2000:

http://www.sqlusa.com/bestpractices2005/exportxml/" target="_blank" rel="nofollow">http://www.sqlusa.com/bestpractices...exportxml/

Kalman Toth, Database, Data Warehouse and BI Architect
The Best SQL Server 2005 Training in the World

Acceptable Use Policy