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 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 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 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 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 Steve Jones - SSC Editor - Wednesday, April 19, 2017 2:46 AM

we could use another one, so please feel free.
By Steve Jones - SSC Editor - Wednesday, April 19, 2017 8:02 AM

No hurry
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 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 amarreddy23 - Wednesday, April 19, 2017 2:54 AM

OK will try to send it out ASAP.
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 - Sunday, April 30, 2017 11:31 AM

Thanks, I'll take a look as soon as I can
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 Steve Jones - SSC Editor - Tuesday, September 5, 2017 6:31 PM

I think we're good. I'll close this for now.
By jbieber - Tuesday, September 5, 2017 12:18 PM

Are you still looking for articles on this?
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.