The OUTPUT Clause for INSERT and DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
2026-01-02 (first published: 2017-05-25)
308,921 reads
Amarendra Reddy Thummeti
- Interests: SQL Server, Databases , BI tools
Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2020-01-10 (first published: 2017-04-26)
15,546 reads
The OUTPUT Clause for the MERGE Statements
In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.
2019-03-08 (first published: 2017-06-08)
170,157 reads
The OUTPUT Clause for UPDATE Statements
In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.
2017-06-06
194,523 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Boulevard Timur,Telpon/Wa 0821-8200-239
Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec. Klp. Gading, Jkt Utara,...
BCA KCP Condet,Telpon/Wa 0821-8200-239
Jalan Raya Condet RT 006/03 Kec. Kramat Jati, Jakarta Timur 13530, RT.1/RW.3, Balekambang, Kec....
BCA KCP Kas AEON Mall JGC,Telpon/Wa 0821-8200-239
Aeon Mall, Jl. Jkt Garden City Boulevard No.69 GF Unit G, RT.1/RW.6, Kota Adm,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers