Browse by Tags

• merge
• sql server
• sql server 2008
• t-sql

• Obtaining rowcounts when using Composable DML [T-SQL]

  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... Posted Thursday, February 7, 2013 2:59 PM by jamiet | 6 Comments Filed under: Composable DML, merge, sql server, t-sql

• Composable DML cannot insert into a table with a FOREIGN KEY

  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... Posted Friday, August 10, 2012 11:48 AM by jamiet | 10 Comments Filed under: Composable DML, sql server

• Using Composable DML to maintain entity history [T-SQL]

  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... Posted Friday, July 13, 2012 3:09 PM by jamiet | 2 Comments Filed under: Composable DML, sql server, t-sql

• Exploring Composable DML

  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... Posted Monday, August 31, 2009 12:33 AM by jamiet | 4 Comments Filed under: Composable DML, sql server 2008, t-sql