output clause

Using SQL Server's Output Clause

  • Article

When you are inserting, updating, or deleting records from a table, SQL Server keeps track of the records that are changed in two different pseudo tables: INSERTED, and DELETED. These tables are normally used in DML triggers. If you use the OUTPUT clause on an INSERT, UPDATE, DELETE or MERGE statement you can expose the records that go to these pseudo tables to your application and/or T-SQL code.

2012-03-26

3,728 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Autocorrect for Git

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Autocorrect for Git

Your Favorite IDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite IDE

Report based on dynamic columns

By ca4fil

Hi all, Can anyone help please? I am trying to do the below report,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers