output clause

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

Forums

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

By Layanan BCA 24 JAM

Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...

BCA KCP Gatot Subroto | Tlp/Wa:0817866887

By Layanan Bank BCA

Tlp/Wa_Cs:0817-866-887. Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, RT.2/RW.2, Karet...

Visit the forum

Question of the Day

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:

SELECT CustomerNameID, CustomerName FROM dbo.CustomerName WHERE CustomerName = LOWER(CustomerName)

CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda Taylor

See possible answers

output clause

Capturing Data Changes

Using temporary tables with OUTPUT clause

OUTPUT values

OUTPUT Targets

Using SQL Server's Output Clause

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

Forums

Stan Phone Number Australia +61-1800868603 Quick Help Guide

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

BCA KCP Gatot Subroto | Tlp/Wa:0817866887

Question of the Day

Detecting Characters