Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Jacob Sebastian — Tue, 25 Aug 2009 01:58:43 GMT

Very nice post Adam!. We do a lot of auditing and this is one of the programmability enhancements I love in SQL Server 2008

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Peso — Tue, 25 Aug 2009 07:30:39 GMT

With Composable DML, we are right now restricted to use INSERT only.

There are issues on Connect to enable all DML with Composable DML.

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Jack Corbett — Tue, 25 Aug 2009 12:44:53 GMT

Nice post Adam. Wish I was working with SQL Server 2008 so I could use MERGE.

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Adam Machanic — Tue, 25 Aug 2009 13:29:41 GMT

Jacob and Jack, glad you enjoyed it.

Peso, thanks for the echo.

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

Jamie Thomson — Sat, 29 Aug 2009 22:40:25 GMT

Just lately I’ve been using T-SQL’s MERGE statement (introduced in SQL Server 2008) and one thing that

Exploring Composable DML

Jamie Thomson — Sun, 30 Aug 2009 22:33:24 GMT

SQL Server 2008 includes a new feature called “Composable DML” which I hadn’t heard about until I read

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Florian Reischl — Sun, 25 Oct 2009 09:26:46 GMT

Great job, Adam!

Especially the part about how to combine the surrogate client id and the generated server identity. This, in combination with TVPs, enables set-based and really high performing client solutions.

Greets

Flo

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

SSIS Junkie — Wed, 06 Jan 2010 18:46:24 GMT

The new T-SQL MERGE statement in SQL Server 2008 seems to be finding many uses over and above its de

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Vic Kirkpatrick — Wed, 20 Oct 2010 18:42:35 GMT

I just don't understand why you can't get the source values when using OUTPUT with a normal INSERT statement, but you definitely can't. Very frustrating. You can only access the INSERT.* columns. Arrgghhh.

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Peter Schott — Tue, 12 Apr 2011 17:49:34 GMT

I agree, Vic. Very frustrating that OUTPUT and OUTPUT INTO don't give access to the original columns. Been beating my head against that for the last hour or so just to confirm because I couldn't find anything that explicitly said that OUTPUT could _only_ use "inserted" and "deleted" for its values.

Thanks for the writeup, Adam. Looking forward to 2008 so we can do this in a more correct manner.

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Alejandro — Fri, 08 Jun 2012 14:11:03 GMT

Thanks for sharing!

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Alfa — Thu, 09 Aug 2012 05:58:34 GMT

Awesome explanation Adam! Thanks for sharing these powerfule features of merge + Output

re: Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Joshua Dobbelaar — Tue, 22 Jan 2013 17:37:20 GMT

Adam, I've been sharing this excellent article with my team members. We all thank you!