Insert with OUTPUT clause

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by vk-kirov » Insert with OUTPUT clause

13 posts, Page 2 of 2

««1 2

Insert with OUTPUT clause

Rate Topic

Display Mode

Topic Options

Author

Message

SQLRNNR

Posted Thursday, May 20, 2010 10:53 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 6:30 PM
Points: 18,733, Visits: 12,330

Thanks - nice question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #925376

L' Eomot Inversé

Posted Monday, May 31, 2010 11:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:32 PM
Points: 7,080, Visits: 7,125

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #930445

ipkunte

Posted Tuesday, July 06, 2010 2:40 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, September 28, 2010 8:05 AM
Points: 57, Visits: 5

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?

Post #947765

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions