Insert with OUTPUT clause

Question

Insert with OUTPUT clause

vk-kirov

SSCertifiable

Points: 7686
More actions
May 18, 2010 at 9:38 pm

#386960

Comments posted to this topic are about the item Insert with OUTPUT clause

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

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Nice question. Of course I got it wrong, as I thought it would be the same answer as the QotD from 13th of May. 🙂

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

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 2

Good Question .....By Seriously I attempted the question luckly my answer is match with answer....

ziangij SSCrazy Eights Points: 8066 More actions · Answer 3

thanks... i had to read BOL to get this right... 🙂

Richard M. SSCertifiable Points: 7401 More actions · Answer 4

Nice question... with a twist from the QOD from the other day 😀

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

rjv_rnjn Hall of Fame Points: 3023 More actions · Answer 5

A twist on previous question agreed, but I do not agree with the choice of answers. It is a bit too vague to select that as an answer.

sjimmo SSChampion Points: 11139 More actions · Answer 6

Agree with rjv:

A twist on previous question agreed, but I do not agree with the choice of answers. It is a bit too vague to select that as an answer.

Tricky with the select at the end. Good question, makes one think. I do a lot with triggers and output statements and had doubts.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

UMG Developer SSChampion Points: 13482 More actions · Answer 7

Good question, it made me think some. I did refer back to the previous similar question to see what was different, which helped.

Dave Jones - CRC SSC-Addicted Points: 431 More actions · Answer 8

Nice question. I almost got it wrong because when I read it, I assumed the output had a "into @myTable" after it. But when I read it again (and actually paid attention this time), I saw it didn't. 😀

deepak.a SSCertifiable Points: 5330 More actions · Answer 9

deepak.a

SSCertifiable

Points: 5330

May 19, 2010 at 10:50 pm

#1169860

Thanks For the Good Question 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Thanks - nice question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Another good question, but a bit close to the one posted 6 days earlier - I was catching up on QOTD today after a while of not having time so I got to these two questions maybe 15 minutes apart (would have been less if I hadn't spent time thinking about the first one). If I hadn't seen the previous one, and read the references in the explanation and played a bit with output clauses to get a better feel I would probably have guessed this one wrong (picked the syntax error instead of another error).

Tom

ipkunte SSC Enthusiast Points: 123 More actions · Answer 12

I received the following error message when I ran the script on SQL Server 2005.

Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'OUTPUT'.

Can someone put a light on this?