What will the max id be?

Question

What will the max id be?

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

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

anamika.aashiyana17 Grasshopper Points: 20 More actions · Answer 1

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

bkubicek SSChampion Points: 10948 More actions · Answer 2

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 3

SanDroid

SSChampion

Points: 10068

December 27, 2012 at 1:34 pm

#1571970

Great question.

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 4

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 5

asifkareem

Ten Centuries

Points: 1089

January 15, 2013 at 12:55 pm

#1577487

Good But Easy One.

manik_anu SSCrazy Points: 2377 More actions · Answer 6

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.