SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, output clause Rss

   Items 1 to 9 of 9   

The OUTPUT Clause for INSERT & 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.  Read more...
By Amarendra Reddy Thummeti 2017/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,169 reads

OUTPUT Targets

By Steve Jones 2016/09/30 | Category: output clause
Rating: (not yet rated) |  Discuss |   Briefcase | 1,197 reads

The OUTPUT clause and T-SQL Syntax

By pramod singla 2013/07/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,468 reads

MERGE with OUTPUT clause

A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...  Read more...
By 2012/02/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 7,071 reads


By Steve Jones 2012/02/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,748 reads

Dealing with Incomplete Data - A T-SQL Puzzle 1

Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.  Read more...
By Suresh Maganti 2011/11/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,316 reads

Using INSERT / OUTPUT in a SQL Server Transaction

Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were the outcome of the initial INSERT command. Thanks to a Transact/SQL enhancement in SQL Server, this just became much easier and can be done in a single statement... WITHOUT A TRIGGER!  Read more...
By Additional Articles 2010/12/27 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,938 reads

Working with Queues in SQL Server

This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.   Read more...
By Ahmad Alkilani 2010/04/05 | Source: SQLServerCentral.com | Category: queue processing
Rating: |  Discuss |   Briefcase | 10,474 reads

T-SQL Output Clause

By bitbucket-25253 2010/01/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,988 reads
   Items 1 to 9 of 9   
blogs (1)    
cte (1)    
insert (1)    
insert into (1)    
merge (1)    
queue processing (1)    
transactions (1)