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

Kubernetes Pipelines

By

This post continues looking at some of the Kubernetes concepts I’ve been learning with...

Top Modern Data Warehouse questions

By

Below are the top 15 questions I am seeing from customers looking to build...

Importance of Testing

By

I’ve always said if you’re running a script for the first time in a...

Read the latest Blogs

Forums

Azure Elastic jobs

By Evgeny Garaev

Comments posted to this topic are about the item Azure Elastic jobs

Data Challenges and Travel

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Challenges and Travel

Multi column histograms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multi column histograms

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers