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

Content with tags T-SQL, output clause Rss

   Items 1 to 11 of 11   
 

The OUTPUT Clause for the MERGE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.  Read more...
By Amarendra Reddy Thummeti 2017/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,903 reads

The OUTPUT Clause for UPDATE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.   Read more...
By Amarendra Reddy Thummeti 2017/06/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,392 reads

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 | 4,407 reads

OUTPUT Targets

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

The OUTPUT clause and T-SQL Syntax

By pramod singla 2013/07/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,472 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,406 reads

INSERT OUTPUT

By Steve Jones 2012/02/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,751 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 | 5,028 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,503 reads

T-SQL Output Clause

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