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

Blogs

Control Flow Restartability in Azure Data Factory

By Meagan Longoria

I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...

Monday Monitor Tips: Knowing Your RPO

By Steve Jones

A customer was asking recently about the RPO for their estate, and I showed...

Read the latest Blogs

Question of the Day

Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:

CREATE TABLE t0
( id     INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
  gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GO

What happens if you execute the following statements?

select STRING_AGG(field1, ';') within group (order by id)  from t0;

select STRING_AGG(field2, ';') within group (order by id)  from t0;

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

Control Flow Restartability in Azure Data Factory

Monday Monitor Tips: Knowing Your RPO

Webinar tomorrow: The Role of Databases in the Era of AI

Forums

best choice for index when creating a composite key

Best Approach to cutover from Test to Live with new columns and tables added

Table Partitioning SQL server 2022

Question of the Day

STRING_AGG's behavior