Archive for June, 2006

Return XML from database query

Posted in Notebook, T-SQL on June 29th, 2006 by kai – Comments Off

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.

d.Construct Web Conference, Sept 8th 2006

Posted in Events on June 10th, 2006 by kai – Comments Off

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/