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

Articles with tag output clause Rss

Search for any content tagged output clause

   Items 1 to 4 of 4   

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,523 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,937 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
   Items 1 to 4 of 4