What will the max id be?

Question

What will the max id be?

Viewing 5 posts - 31 through 35 (of 35 total)

You must be logged in to reply to this topic. Login to reply

bkubicek SSChampion Points: 10948 More actions · Answer 1

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.

SanDroid SSChampion Points: 10068 More actions · Answer 2

SanDroid

SSChampion

Points: 10068

December 27, 2012 at 1:34 pm

#1571970

Great question.

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 3

malleswarareddy_m

SSCertifiable

Points: 5847

December 31, 2012 at 5:31 am

#1572490

Easy one.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

asifkareem Ten Centuries Points: 1089 More actions · Answer 4

asifkareem

Ten Centuries

Points: 1089

January 15, 2013 at 12:55 pm

#1577487

Good But Easy One.

manik_anu SSCrazy Points: 2397 More actions · Answer 5

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

Manik
You cannot get to the top by sitting on your bottom.