Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, output clause Rss

   Items 1 to 7 of 7   

The OUTPUT clause and T-SQL Syntax

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


By Steve Jones 2012/02/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,731 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,313 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: | Category: t-sql
Rating:  Rate this |   Briefcase | 4,803 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: | Category: queue processing
Rating: |  Discuss |   Briefcase | 10,416 reads

T-SQL Output Clause

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