Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Insert with OUTPUT clause Expand / Collapse
Author
Message
Posted Thursday, May 20, 2010 10:53 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:01 PM
Points: 21,642, Visits: 15,312
Thanks - nice question.



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


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
Posted Monday, May 31, 2010 11:27 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 8,718, Visits: 9,266
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
Post #930445
Posted Tuesday, July 6, 2010 2:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 »

Add to briefcase ««12

Permissions Expand / Collapse