SQLServerCentral

The OUTPUT clause


https://www.sqlservercentral.com/Forums/Topic1811349.aspx

By Steve Jones - SSC Editor - Monday, August 22, 2016 1:53 AM

Looking for a couple articles here. One on basics of OUTPUT for inserts and deletes. One for updates and combining inserted and deleted tables. Auditing is the obvious case, but anything else is OK.

A third one on MERGE would be good as well.
By Jeff Moden - Monday, August 22, 2016 3:55 AM

Gosh... I'd NEVER (and I don't say that word often) use the OUTPUT clause for auditing. That would make auditing code dependent instead of just happening for any change to the table being audited.
By Steve Jones - SSC Editor - Monday, August 22, 2016 9:33 AM

Depends on what you're auditing, but point taken.
By Kenneth.Fisher - Sunday, September 4, 2016 2:15 PM

I did a blog post a few years back on using OUTPUT to backup table changes. I could do an updated version?

Kenneth Fisher
By Steve Jones - SSC Editor - Monday, September 12, 2016 9:19 AM

That would be good. Anything that showcases how to use this. We're lacking some practical articles on this topic.
By ALAN.H.HYNEMAN - Friday, October 14, 2016 4:17 AM

For even more fun why not output into a memory optimized udt and do some additional processing with it, get some metrics around performance differences between outputting to temp vs output to memory.
By TheJimmy - Thursday, October 20, 2016 3:30 AM

I will write an article on using OUTPUT with a MERGE statement if it is still required.
By Steve Jones - SSC Editor - Thursday, October 20, 2016 4:51 AM

Please feel free and submit in the contribution center (click "Write for us" to the left).
By amarreddy23 - Tuesday, April 18, 2017 5:04 PM

Steve,
I have few examples which can explain this , can i work on this article or did u already got some one submitted it?
By Steve Jones - SSC Editor - Wednesday, April 19, 2017 2:46 AM

we could use another one, so please feel free.
By amarreddy23 - Wednesday, April 19, 2017 2:54 AM

OK will try to send it out ASAP.
By Steve Jones - SSC Editor - Wednesday, April 19, 2017 8:02 AM

No hurry
By amarreddy23 - Friday, April 21, 2017 5:29 AM

Steve,
I have submitted one article today for Insert and Deletes with The OUTPUT Clause for INSERT & DELETE Statements title.

I will be working on next two,
updates and combining inserted and deleted tables and one on MERGE
By amarreddy23 - Saturday, April 29, 2017 4:02 PM

Steve,
I Submitted the 2nd one with The OUTPUT Clause for UPDATE Statements. i followed the similar format as the 1st one . i will be working on the MERGE now.
By Steve Jones - SSC Editor - Sunday, April 30, 2017 11:31 AM

Thanks, I'll take a look as soon as I can
By amarreddy23 - Friday, May 5, 2017 7:44 AM

Steve,
I submitted a good one on the last one output clause for MERGE statements as well.
Will be waiting for your feedback.
By Steve Jones - SSC Editor - Monday, May 8, 2017 3:30 AM

We'll get to it. It can take a week or so to get through articles, depending on how many submissions we get.
By jbieber - Tuesday, September 5, 2017 12:18 PM

Are you still looking for articles on this?
By Steve Jones - SSC Editor - Tuesday, September 5, 2017 6:31 PM

I think we're good. I'll close this for now.