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 Tuesday, May 18, 2010 9:38 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
Comments posted to this topic are about the item Insert with OUTPUT clause
Post #924033
Posted Wednesday, May 19, 2010 12:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:57 AM
Points: 13,636, Visits: 10,519
Nice question. Of course I got it wrong, as I thought it would be the same answer as the QotD from 13th of May.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #924078
Posted Wednesday, May 19, 2010 12:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
Good Question .....By Seriously I attempted the question luckly my answer is match with answer....
Post #924081
Posted Wednesday, May 19, 2010 2:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 2,017, Visits: 369
thanks... i had to read BOL to get this right...
Post #924109
Posted Wednesday, May 19, 2010 7:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:56 AM
Points: 1,093, Visits: 2,617
Nice question... with a twist from the QOD from the other day



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #924265
Posted Wednesday, May 19, 2010 7:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:31 AM
Points: 513, Visits: 430
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.
Post #924275
Posted Wednesday, May 19, 2010 8:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:47 AM
Points: 2,919, Visits: 2,525
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
Post #924329
Posted Wednesday, May 19, 2010 9:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Good question, it made me think some. I did refer back to the previous similar question to see what was different, which helped.
Post #924427
Posted Wednesday, May 19, 2010 12:44 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:09 PM
Points: 61, Visits: 237
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.
Post #924585
Posted Wednesday, May 19, 2010 10:50 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 2, 2014 9:57 AM
Points: 554, Visits: 863
Thanks For the Good Question :)
Post #924810
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse