SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Ben Kubicek / What will the max id be? / Latest Posts

RE: What will the max id be?

manik123 — Mon, 21 Jan 2013 11:44:50 GMT

if we use delete instead of truncate reseed will not work...... the answer should be 4,8........:-P

RE: What will the max id be?

asifkareem — Tue, 15 Jan 2013 12:55:50 GMT

Good But Easy One.

RE: What will the max id be?

malleswarareddy_m — Mon, 31 Dec 2012 05:31:49 GMT

Easy one.

RE: What will the max id be?

SanDroid — Thu, 27 Dec 2012 13:34:54 GMT

Great question.

RE: What will the max id be?

bkubicek — Sat, 22 Dec 2012 06:11:06 GMT

If you run all the lines in the question in a query window you will see you don't get an invalid object error. The table doesn't get dropped before the selects are complete.

RE: What will the max id be?

anamika.aashiyana17 — Sat, 22 Dec 2012 01:24:23 GMT

i think the answer will be "invalid object" as in last query we are dropping the table.

RE: What will the max id be?

anamika.aashiyana17 — Sat, 22 Dec 2012 01:22:34 GMT

i think the answer will be "invalid object" as in last query we are dropping the table.

RE: What will the max id be?

Danny Ocean — Thu, 20 Dec 2012 06:32:59 GMT

Thanks for memorized .

RE: What will the max id be?

udayroy15 — Thu, 20 Dec 2012 02:11:11 GMT

from beginning............

RE: What will the max id be?

KWymore — Wed, 19 Dec 2012 20:47:46 GMT

Good, straight-forward question on the basics. I'm surprised how many have gotten this wrong. I guess that means there are a lot of people learning a valuable point.

RE: What will the max id be?

Revenant — Wed, 19 Dec 2012 12:06:40 GMT

It was easy, but really good for getting back to the basics. Thanks!

RE: What will the max id be?

EL Jerry — Wed, 19 Dec 2012 10:37:58 GMT

Thanks for the easy question.Saludos,

RE: What will the max id be?

Primo Dang — Wed, 19 Dec 2012 09:55:38 GMT

Weird, I was so sure I recently got a question wrong exactly because I thought truncate reseeded the identity and it actually didn't. Guess I was just confused. :-PThanks for the good question, apparently I really needed to learn that one.

RE: What will the max id be?

Mike Hays — Wed, 19 Dec 2012 08:04:52 GMT

Good Question, learned something today.

RE: What will the max id be?

keith.fearnley — Wed, 19 Dec 2012 07:29:19 GMT

Hmm, I answered too quickly (being on holiday now), thinking that without specifying the column list, the INSERT would expect values for both columns and hence would fail the inserts (even though an identity insertion wouldn't be allowed either). Doh. Thanks for what should have been an easy one!

RE: What will the max id be?

Dana Medley — Wed, 19 Dec 2012 07:06:28 GMT

Thanks for the easy one today.

RE: What will the max id be?

Dave62 — Wed, 19 Dec 2012 07:01:54 GMT

[quote][b]palotaiarpad (12/19/2012)[/b][hr]I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.[/quote]Hello, if resetting the identity is a possible source of inconsistency you may try using DELETE instead of TRUNCATE. DELETE will remove the data without resetting the identity.

RE: What will the max id be?

Sean of the Lynchmob — Wed, 19 Dec 2012 05:44:41 GMT

[quote][b]palotaiarpad (12/19/2012)[/b][hr]why is the identity resetted after a truncate? For me is a possible source of inconsitency.[/quote]As Lokesh has already explained, resetting the identity seed is a characteristic of the 'truncate' command. If you want to retain the seed then you use 'delete' instead. So, there's no inconsistency, it is just a case of using the right command according to your needs.At least you learnt something, so from that point of view it is a good question. ;-)

RE: What will the max id be?

L' Eomot Inversé — Wed, 19 Dec 2012 05:30:56 GMT

[quote][b]SQL Kiwi (12/19/2012)[/b][hr]Another good one. 19% wrong right now :blink:[/quote]Yes, a good one. And in the last 6 hours the wrong rate has grown from 19% to 27%, which seems rather high for such an easy question.

RE: What will the max id be?

Dineshbabu — Wed, 19 Dec 2012 05:05:08 GMT

Easy one.. Remembering basics...

RE: What will the max id be?

Hugo Kornelis — Wed, 19 Dec 2012 04:40:43 GMT

[quote][b]palotaiarpad (12/19/2012)[/b][hr]Could someone please explain, why is the identity resetted after a truncate?[/quote]Because conceptually, TRUNCATE TABLE is closer to DROP / CREATE than to DELETE.

RE: What will the max id be?

(Bob Brown) — Wed, 19 Dec 2012 04:34:00 GMT

Thanks for a nice easy Wednesday question.

RE: What will the max id be?

kapil_kk — Wed, 19 Dec 2012 04:03:08 GMT

bcoz it is its behavior that every time we execute TRUNCATE command it will reset the identity value..

RE: What will the max id be?

Stewart "Arturius" Campbell — Wed, 19 Dec 2012 03:56:31 GMT

Good back-to-basics question, Thanks

RE: What will the max id be?

Lokesh Vij — Wed, 19 Dec 2012 03:28:12 GMT

[quote][b]palotaiarpad (12/19/2012)[/b][hr] For me is a possible source of inconsitency.[/quote]Not sure why you said this as "inconsistency"...it's just the property of TRUNCATE command!

RE: What will the max id be?

Lokesh Vij — Wed, 19 Dec 2012 03:26:06 GMT

[quote][b]palotaiarpad (12/19/2012)[/b][hr]I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.[/quote]TRUNCATE command apart from removing data from the table, resets the seed value of the identity column defined in the table.Another command to re-seed identity is DBCC CHECKIDENT. It can be used something like below:[code="sql"]DBCC CHECKIDENT ('test_trun', RESEED, 0)[/code]

RE: What will the max id be?

IgorMi — Wed, 19 Dec 2012 02:46:02 GMT

Nice question.Thanks

RE: What will the max id be?

palotaiarpad — Wed, 19 Dec 2012 02:34:50 GMT

I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.

RE: What will the max id be?

Paul White — Wed, 19 Dec 2012 00:11:43 GMT

Another good one. 19% wrong right now :blink:

RE: What will the max id be?

Koen Verbeeck — Tue, 18 Dec 2012 23:56:42 GMT

Easy one, thanks.

RE: What will the max id be?

demonfox — Tue, 18 Dec 2012 23:20:58 GMT

easy ...truncate resets the identity;It's a coincidence , I was just discussing it with my colleague about inserting a row in between identity inserted column. And yes, Truncate popped up as an option :)

RE: What will the max id be?

kapil_kk — Tue, 18 Dec 2012 23:00:25 GMT

easy one for Wednesday :-)revision of basics........

RE: What will the max id be?

Lokesh Vij — Tue, 18 Dec 2012 22:17:45 GMT

Thanks for reminding the basics :-)

RE: What will the max id be?

SQLRNNR — Tue, 18 Dec 2012 21:24:39 GMT

EZPZ

RE: What will the max id be?

bitbucket-25253 — Tue, 18 Dec 2012 20:52:28 GMT

Nice back to basics question - thanks

What will the max id be?

bkubicek — Tue, 18 Dec 2012 20:51:48 GMT

Comments posted to this topic are about the item [B]What will the max id be?[/B]