OUTPUT Targets

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715912

    Comments posted to this topic are about the item OUTPUT Targets

  • This was removed by the editor as SPAM

  • stuart 24336

    SSC Enthusiast

    Points: 112

    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

    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 🙂

  • twin.devil

    SSC-Insane

    Points: 22208

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

    Thanks for sharing Steve.

  • Koen Verbeeck

    SSC Guru

    Points: 258942

    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: 3946

    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: 12227

    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

  • George Vobr

    SSCrazy Eights

    Points: 8980

    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: 715912

    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

    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

    Thanks for the question.

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

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