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.
2019-03-15 (first published: 2017-05-25)
32,215 reads
Amarendra Reddy Thummeti
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)
18,462 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
15,288 reads
Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2017-04-26
7,085 reads
Blogs
Kubernetes Pipelines
By Steve Jones
This post continues looking at some of the Kubernetes concepts I’ve been learning with...
Top Modern Data Warehouse questions
By James-Serra
Below are the top 15 questions I am seeing from customers looking to build...
Importance of Testing
I’ve always said if you’re running a script for the first time in a...
Forums
empty table is large
I have a table used for staging during ETL. It is empty most of...
XP_CMDSHELL Error
Hello, I have set up and configured xp_cmdshell using a proxy account and I...
Ask SSC