Contents tagged with SQL 2005
-
Who Needs ORM, I've got SQL 2005
One of the coolest features of SQL 2005 is the XML support. With the recent enhancements to the FOR XML option, you can really get a lot of mileage out of SQL. A common task in a lot of applications involves retrieving an item with many children. Due to the way a lot of systems are built, this usually ends up resulting in a lot of extra queries. For example, suppose I have a customer entity like so: