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: Today @ 1:53 AM
Points: 467, Visits: 867
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