Browse by Tags

In my August 2009 blog post Exploring Composable DML I introduced a new feature in SQL Server 2008 called Composable DML and also outlined one of its limitations; namely that data from the OUTPUT cannot be aggregated prior to insertion. Composable DML Read More...

I have written on here about the benefits of Composable DML (i.e. the ability to insert the data outputted from an OUTPUT clause into a table) before however I discovered a limitation today that I think is worth sharing. Basically, the table that you’re Read More...

I recently inherited a data warehousing SQL Server solution from my good buddy James Rowland-Jones (you may know him from his more auspicious role on the SQLPass board ) and it contained a very cool technique of using composable DML (a feature that arrived Read More...

SQL Server 2008 includes a new feature called “Composable DML” which I hadn’t heard about until I read Adam’s post Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE . Composable DML is a new feature in T-SQL that allows you to use the data Read More...