Fun with IDENTITY

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 Nakul Vachhrajani » Fun with IDENTITY - Part II

28 posts, Page 2 of 3

««1 2 3 »»

Fun with IDENTITY - Part II

Rate Topic

Display Mode

Topic Options

Author

Message

Dhruvesh Shah

Posted Wednesday, October 06, 2010 5:06 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542, Visits: 187

Great one....

Post #999130

Daniel Bowlin

Posted Wednesday, October 06, 2010 6:58 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:53 AM
Points: 2,672, Visits: 2,416

Table variables don't participate in transactions.....hmmm.....I suppose that makes sense. I definitely learned something today. Thanks.

Post #999239

webrunner

Posted Wednesday, October 06, 2010 8:56 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:05 PM
Points: 2,117, Visits: 2,209

Thanks for the question. I got it wrong but learned a valuable lesson about table variables.

- webrunner

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Post #999444

mtillman-921105

Posted Wednesday, October 06, 2010 9:46 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:54 AM
Points: 749, Visits: 3,767

Terrific question thanks.

______________________________________________________________________
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

Post #999535

SQLRNNR

Posted Wednesday, October 06, 2010 10:37 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

Nice Question - Thanks

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 #999603

rockvilleaustin

Posted Wednesday, October 06, 2010 11:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:49 PM
Points: 168, Visits: 107

Great question! Learned something new again!

Post #999642

Jason Shadonix

Posted Wednesday, October 06, 2010 2:47 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:27 AM
Points: 1,407, Visits: 2,020

Nice!

Jason Shadonix
MCTS, SQL 2005

Post #999915

L' Eomot Inversé

Posted Wednesday, October 06, 2010 4:22 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:59 AM
Points: 7,076, Visits: 7,115

Good question.

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 #1000033

cengland0

Posted Friday, October 08, 2010 2:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

Good question. I almost missed it because I didn't notice it was loading a table variable at first. I was saved because I remember the previous question that seemed exactly the same and almost answered the same way. I knew there must have been some difference so I looked closer at the query and then noticed it wasn't an actual table but a table variable instead. Whew! Close call on that one.

Lesson learned: Pay close attention to the details.

Post #1001071

Kevin Gill

Posted Friday, October 08, 2010 3:20 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:34 AM
Points: 931, Visits: 222

Didn't notice it was a table variable! Gah! Smile

-------------------------------
Oh no!

Post #1001099

« Prev Topic | Next Topic »

28 posts, Page 2 of 3

««1 2 3 »»

Permissions