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,365 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 | 4,475 reads

INSERT OUTPUT

By Steve Jones 2012/02/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,694 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,304 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,543 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 | 9,969 reads

T-SQL Output Clause

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