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
Author
Message
Posted Tuesday, October 6, 2009 7:54 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

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.

And
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