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
Posted Thursday, May 20, 2010 10:53 AM



Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 17,812, Visits: 15,738
Thanks - nice question.

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


Posting Performance Based Questions - Gail Shaw
Post #925376
Posted Monday, May 31, 2010 11:27 AM



Group: General Forum Members
Last Login: Sunday, October 19, 2014 11:12 AM
Points: 7,791, Visits: 9,545
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).

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