T-SQL - What is the output of the statement

Question

Post reply

T-SQL - What is the output of the statement

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 1

Mine too.

I did get a new computer yesterday, but even with all the 'greatest OS ever', I'm pretty sure Win7 can't read my mind 🙂

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 2

Not only did I go the quetion right, I also had a note in the discussion. How about that?

This without logging in to the site.

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 3

SA-1 (10/6/2009)
Not only did I go the quetion right, I also had a note in the discussion. How about that?
This without logging in to the site.

Posted in June none the less.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

Dan Guzman (10/6/2009)
SA-1 (10/6/2009)
Not only did I go the quetion right, I also had a note in the discussion. How about that?
This without logging in to the site.
Posted in June none the less.

aaaaaahhhh .... that explains why it was already answered.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

davoscollective SSCertifiable Points: 6355 More actions · Answer 5

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.