OUTPUT clause in UPDATE statements

added by AndreiR23
8/23/2012 5:35:32 AM

1 Kicks, 95 Views

Sometimes you need to update data in a table and then update data in another table but based on a filter condition found from the first table. Use the OUTPUT clause to obtain data from the UPDATEd row(s) in order to use them further. Also this is a "thread-safe" way to obtain data.