Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

T-SQL - What is the output of the statement Expand / Collapse
Posted Tuesday, October 6, 2009 7:54 PM



Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
Good question, I'm just disappointed that
OUTPUT inserted.column

returns values that have updated existing values.

OUTPUT Deleted.column

returns the existing values that were updates.

I suppose its more info that just which rows were updated. There's probably been a lot of thought gone into this that I am not giving MS credit for.
Post #798897
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse