SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by vk-kirov / Insert with OUTPUT clause / Latest Posts

RE: Insert with OUTPUT clause

ipkunte — Tue, 06 Jul 2010 02:40:48 GMT

I received the following error message when I ran the script on SQL Server 2005.Msg 170, Level 15, State 1, Line 2Line 2: Incorrect syntax near 'OUTPUT'.Can someone put a light on this?

RE: Insert with OUTPUT clause

L' Eomot Inversé — Mon, 31 May 2010 11:27:18 GMT

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).

RE: Insert with OUTPUT clause

SQLRNNR — Thu, 20 May 2010 10:53:26 GMT

Thanks - nice question.

RE: Insert with OUTPUT clause

deepak.a — Wed, 19 May 2010 22:50:48 GMT

Thanks For the Good Question :)

RE: Insert with OUTPUT clause

Dave Jones - CRC — Wed, 19 May 2010 12:44:22 GMT

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. :-D

RE: Insert with OUTPUT clause

UMG Developer — Wed, 19 May 2010 09:52:20 GMT

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

RE: Insert with OUTPUT clause

sjimmo — Wed, 19 May 2010 08:17:02 GMT

Agree with rjv:[quote]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. [/quote]Tricky with the select at the end. Good question, makes one think. I do a lot with triggers and output statements and had doubts.

RE: Insert with OUTPUT clause

rjv_rnjn — Wed, 19 May 2010 07:17:12 GMT

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.

RE: Insert with OUTPUT clause

Richard M. — Wed, 19 May 2010 07:01:55 GMT

Nice question... with a twist from the QOD from the other day :-D

RE: Insert with OUTPUT clause

ziangij — Wed, 19 May 2010 02:08:00 GMT

thanks... i had to read BOL to get this right... :-)

RE: Insert with OUTPUT clause

Sree Arjun Div — Wed, 19 May 2010 00:52:51 GMT

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

RE: Insert with OUTPUT clause

Koen Verbeeck — Wed, 19 May 2010 00:46:53 GMT

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

Insert with OUTPUT clause

vk-kirov — Tue, 18 May 2010 21:38:04 GMT

Comments posted to this topic are about the item [B]Insert with OUTPUT clause[/B]