Browse by Tags

• Composable DML
• sql server
• sql server integration services
• ssis
• 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 07, 2013 2:59 PM by jamiet | 6 Comments Filed under: Composable DML, merge, sql server, t-sql

• The current state of a MERGE Destination for SSIS

  Hugo Tap asked me on Twitter earlier today whether or not there existed a SSIS Dataflow Destination component that enabled one to MERGE data into a table rather than INSERT it. Its a common request so I thought it might be useful to summarise the current Read More... Posted Friday, December 07, 2012 12:18 PM by jamiet | 2 Comments Filed under: merge, sql server integration services, ssis

• MERGE and OUTPUT – the swiss army knife of T-SQL

  The new T-SQL MERGE statement in SQL Server 2008 seems to be finding many uses over and above its de facto UPSERT usage scenario, probably the most popular of which is its ability to update one table from another in an ANSI-compliant manner as detailed Read More... Posted Wednesday, January 06, 2010 7:46 PM by jamiet | 6 Comments Filed under: merge, t-sql

• Extracting insert, update, delete rowcounts from T-SQL MERGE

  Just lately I’ve been using T-SQL’s MERGE statement (introduced in SQL Server 2008) and one thing that I needed to do was extract rowcounts for each DML operation (i.e. INSERT, UPDATE, DELETE) conducted by a MERGE. I was surprised to find that while @@ROWCOUNT Read More... Posted Sunday, August 30, 2009 1:54 AM by jamiet | 9 Comments Filed under: merge, sql server, t-sql