OUTPUT Targets

Question

OUTPUT Targets

Steve Jones - SSC Editor

SSC Guru

Points: 737630
More actions
September 29, 2016 at 10:38 pm

#74546

Comments posted to this topic are about the item OUTPUT Targets
September 30, 2016 at 12:45 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

stuart 24336 SSC Enthusiast Points: 123 More actions · Answer 1

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.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

Nice and easy question. Had a scratch due to the typo.

Thanks for sharing Steve.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 4

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 5

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

sknox SSChampion Points: 12388 More actions · Answer 6

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.

sestell1 SSChampion Points: 10230 More actions · Answer 7

sestell1

SSChampion

Points: 10230

September 30, 2016 at 6:56 am

#1904140

George Vobr SSChampion Points: 10056 More actions · Answer 8

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/

Steve Jones - SSC Editor SSC Guru Points: 737630 More actions · Answer 9

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

Gary Varga SSC Guru Points: 82166 More actions · Answer 10

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!!!

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

akljfhnlaflkj

SSC Guru

Points: 76202

October 3, 2016 at 11:56 am

#1904503

Thanks for the question.

OUTPUT Targets

Cookies on SQLServerCentral