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 ««123»»

Fun with IDENTITY - Part II Expand / Collapse
Author
Message
Posted Wednesday, October 06, 2010 5:06 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
Great one....
Post #999130
Posted Wednesday, October 06, 2010 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
Table variables don't participate in transactions.....hmmm.....I suppose that makes sense. I definitely learned something today. Thanks.
Post #999239
Posted Wednesday, October 06, 2010 8:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:38 PM
Points: 2,290, Visits: 2,545
Thanks for the question. I got it wrong but learned a valuable lesson about table variables.

- webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"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
Posted Wednesday, October 06, 2010 9:46 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 8:59 AM
Points: 754, Visits: 3,813
Terrific question thanks.

______________________________________________________________________
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Post #999535
Posted Wednesday, October 06, 2010 10:37 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 3:56 PM
Points: 20,466, Visits: 14,099
Nice Question - Thanks



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 #999603
Posted Wednesday, October 06, 2010 11:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 03, 2013 1:29 PM
Points: 168, Visits: 113
Great question! Learned something new again!
Post #999642
Posted Wednesday, October 06, 2010 2:47 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:43 AM
Points: 1,477, Visits: 2,100
Nice!

Jason Shadonix
MCTS, SQL 2005
Post #999915
Posted Wednesday, October 06, 2010 4:22 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 8,288, Visits: 8,739
Good question.

Tom
Post #1000033
Posted Friday, October 08, 2010 2:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Friday, October 08, 2010 3:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 11, 2014 9:53 AM
Points: 1,086, Visits: 288
Didn't notice it was a table variable! Gah!

-------------------------------
Oh no!
Post #1001099
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse