Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2020-01-10 (first published: 2017-04-26)
13,352 reads
Amarendra Reddy Thummeti
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)
108,814 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)
55,289 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
62,515 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL 2017 MLS - cant add new python packages
Hi I'm new-ish to MLS and have been trying to add new python packages...
Find row closest to date
Just having trouble getting this to work as I hoped. Trying to extract entire...
SQL Query - FULL JOIN multiple tables but return NULL results
Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no...
Ask SSC