SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by dun / Identity Crisis / Latest Posts

RE: Identity Crisis

rizwan.inam — Thu, 05 Nov 2009 01:11:19 GMT

Thanx Dun:-)

RE: Identity Crisis

dun — Wed, 04 Nov 2009 06:28:42 GMT

A good explanation on TRUNCATE vs DELETE can be found at [url]http://www.mssqltips.com/tip.asp?tip=1080[/url].

RE: Identity Crisis

rizwan.inam — Wed, 04 Nov 2009 02:37:02 GMT

What is the Difference between Truncate Table and Delete Table

RE: Identity Crisis

BudaCli — Fri, 30 Oct 2009 07:59:54 GMT

[quote][b]VM-723206 (10/30/2009)[/b][hr]Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.[/quote]Welcome to the party. Not as easy as 1 2 3 ...

RE: Identity Crisis

VM-723206 — Fri, 30 Oct 2009 05:54:35 GMT

Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.

RE: Identity Crisis

ck9663 — Thu, 29 Oct 2009 12:09:31 GMT

[quote][b]SanjayAttray (10/29/2009)[/b][hr]Damn. I missed the increment/seed part. Generally we used (1,1) for identity column and its (1,3) in the question.[/quote]That hit me, too...:angry:

RE: Identity Crisis

Steve Jones - SSC Editor — Thu, 29 Oct 2009 10:26:03 GMT

I have added the truncate item to the explanation.

RE: Identity Crisis

SanjayAttray — Thu, 29 Oct 2009 09:27:49 GMT

Damn. I missed the increment/seed part. Generally we used (1,1) for identity column and its (1,3) in the question.

RE: Identity Crisis

Michael Poppers — Thu, 29 Oct 2009 08:12:53 GMT

[quote][b]Mark Harr (10/29/2009)[/b][hr]Shoot! I had the identity increment right, but forgot about truncate table resetting the seed value.[/quote]There was a recent question which brought that point out (maybe Mark missed it :-)). I appreciate this question's showing an aspect of IDENTITY() with which I wasn't familiar.

RE: Identity Crisis

Michael Poppers — Thu, 29 Oct 2009 08:10:28 GMT

[quote][b]kramaswamy (10/29/2009)[/b][hr]bah. automatically assumed it was seeded with increments of 1. i've never used a non-1 increment personally :/[/quote]Ditto :-).

RE: Identity Crisis

Mark Harr — Thu, 29 Oct 2009 06:39:22 GMT

Shoot! I had the identity increment right, but forgot about truncate table resetting the seed value.

RE: Identity Crisis

kramaswamy — Thu, 29 Oct 2009 06:13:53 GMT

bah. automatically assumed it was seeded with increments of 1. i've never used a non-1 increment personally :/

RE: Identity Crisis

daniel.surridge — Thu, 29 Oct 2009 03:56:00 GMT

In your explanation 'According to BOL, "If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used."' you omit to say that this is for TRUNCATE.

RE: Identity Crisis

Carlo Romagnano — Thu, 29 Oct 2009 02:49:49 GMT

[quote][b]San-847017 (10/28/2009)[/b][hr]I always increment identity column with default value.[/quote]I used a seed = 1 and an increment of 5 and in another table seed = 2 and an increment of 5. So table A always has last digit = 1 or 6 and table B 2 and 7.When I reference in table C the two table above, I know thanks to the last digit which table is linked.

RE: Identity Crisis

BudaCli — Thu, 29 Oct 2009 00:08:01 GMT

Nice one, realised my mistake after running the qry on management studio.

RE: Identity Crisis

Joy Smith San — Wed, 28 Oct 2009 22:45:22 GMT

Gud question. I had forgotten abt incremental value as I never use it. I always increment identity column with default value.

Identity Crisis

dun — Wed, 28 Oct 2009 21:31:04 GMT

Comments posted to this topic are about the item [B]Identity Crisis[/B]