What will the max id be?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ben Kubicek » What will the max id be?

Add to briefcase

36 posts, Page 4 of 4

What will the max id be?

Expand / Collapse

Author

Message

anamika.aashiyana17

Posted Saturday, December 22, 2012 1:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 7:39 AM
Points: 2, Visits: 4

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

Post #1399663

Posted Saturday, December 22, 2012 6:11 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, February 01, 2013 8:13 AM
Points: 1,490, Visits: 388

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.

Post #1399674

Posted Thursday, December 27, 2012 1:34 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Great question.

Post #1400738

malleswarareddy_m

Posted Monday, December 31, 2012 5:31 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:00 PM
Points: 1,850, Visits: 985

Easy one.

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

Post #1401363

Posted Tuesday, January 15, 2013 12:55 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:07 PM
Points: 606, Visits: 136

Good But Easy One.

Post #1407440

Posted Monday, January 21, 2013 11:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:18 AM
Points: 152, Visits: 155

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

Tongue

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

Post #1409663

« Prev Topic | Next Topic »

Add to briefcase

36 posts, Page 4 of 4

Permissions

Expand / Collapse