Return XML from database query

Notebook, T-SQL

By appending FOR XML auto to the end of your sql statement you can have your sql recordset returned as XML. A very useful utility.

SELECT * FROM [Table Name] FOR XML auto

Depending whether you pull from one or multiple tables, your output is structured XML based on the database schema. In situations we you are joining two tables there are two ways to have data returned in a clean way, (1) User a View or (2) User sub-queries.

Comments off

d.Construct Web Conference, Sept 8th 2006

Events

d.Construct is an affordable, one-day conference aimed at those building the latest generation of web-based applications. The event discusses how new technology is transforming the web from a document delivery system into an application platform.

http://dconstruct.org/

9-5:30pm, Sept 8th 2006
Brighton Corn Exchange

For a list of all the speakers,

http://2006.dconstruct.org/speakers/

Comments off