Retrieve data in XML format
SELECT * FROM tablename ORDER BY fieldname FOR XML AUTO, ELEMENTS
Retrieve a list of tables
SELECT name FROM sysobjects WHERE xType = 'U' ORDER BY name
SELECT * FROM tablename ORDER BY fieldname FOR XML AUTO, ELEMENTS
SELECT name FROM sysobjects WHERE xType = 'U' ORDER BY name