OUTPUT Targets
-
Comments posted to this topic are about the item OUTPUT Targets
-
This was removed by the editor as SPAM
-
This should also include 'as a result set' or 'as client output', i.e. it doesn't have to be targeted to a table or variable.
-
Stewart "Arturius" Campbell (9/30/2016)
Nice, easy question to end the week on, thanks Steve.Just a point of confusion in the options:
a table variable, a table in the table, or a temp table
I recon that should have been
a table in the database
I must admit, that had me scratching my head quite a bit.
+1 🙂
-
Nice and easy question. Had a scratch due to the typo.
Thanks for sharing Steve.
-
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
pmadhavapeddi22 (9/30/2016)
Stewart "Arturius" Campbell (9/30/2016)
Nice, easy question to end the week on, thanks Steve.Just a point of confusion in the options:
a table variable, a table in the table, or a temp table
I recon that should have been
a table in the database
I must admit, that had me scratching my head quite a bit.
+1 🙂
I agree. I was also surprised to see it did not mention that it can also go to another INSERT, UPDATE, DELETE, or MERGE statement
-
Stewart "Arturius" Campbell (9/30/2016)
Nice, easy question to end the week on, thanks Steve.Just a point of confusion in the options:
a table variable, a table in the table, or a temp table
I recon that should have been
a table in the database
I must admit, that had me scratching my head quite a bit.
Y'know Steve makes these typos to punish us for not writing our own QotDs, right? 😀
Actually, the question is still slightly incorrect. It's missing one possible target: a result set. Maybe it's overlooked because it's the default, but it's still another destination for the data from the OUTPUT clause.
-
-
twin.devil (9/30/2016)
Nice and easy question. Had a scratch due to the typo.Thanks for sharing Steve.
+1 🙂
Nice explanation the OUTPUT clause is in: https://www.simple-talk.com/sql/learn-sql-server/implementing-the-output-clause-in-sql-server-2008/
-
Stewart "Arturius" Campbell (9/30/2016)
Nice, easy question to end the week on, thanks Steve.Just a point of confusion in the options:
a table variable, a table in the table, or a temp table
I recon that should have been
a table in the database
I must admit, that had me scratching my head quite a bit.
Thanks. Typo on my part
-
Steve Jones - SSC Editor (9/30/2016)
Stewart "Arturius" Campbell (9/30/2016)
Nice, easy question to end the week on, thanks Steve.Just a point of confusion in the options:
a table variable, a table in the table, or a temp table
I recon that should have been
a table in the database
I must admit, that had me scratching my head quite a bit.
Thanks. Typo on my part
Ironically for the benefit of us all. We really had to be sure that we thought this one through. Thanks.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
-
Thanks for the question.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply