Using temporary tables with OUTPUT clause
-
Comments posted to this topic are about the item Using temporary tables with OUTPUT clause
-
Nice, easy question to end the week on, thanks Junior
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex” -
4*2 = 8
-
Same thing here.
-
The INSERT produces a "(4 row(s) affected)" message, so does the UPDATE.
Since nothing produced a "(8 row(s) affected)" message, I assumed the question only applied to the result of the UPDATE. The question could have been worded better to make that clear, but "(4 row(s) affected)" is the only valid answer.
-
Assumptions do Not Always lead to mistakes, but Most Mistakes are Caused by Assumptions. My personal experience, begins with DOS 3. 🙂
-
Great question.
Wasn't sure which answer would be correct as I knew it would return 4 row(s) affected twice and I guessed incorrectly.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply