Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag output clause Rss

   Items 1 to 8 of 8   

The OUTPUT clause and T-SQL Syntax

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

Using SQL Server's 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.  Read more...
By Additional Articles 2012/03/26 | Source: Database Journal | Category: output clause
Rating: (not yet rated)  Rate this |   Briefcase | 3,443 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 | 6,300 reads


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

T-SQL Output Clause

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