Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

What will the max id be? Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 7:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:34 AM
Points: 1,827, Visits: 1,361
Thanks for the easy one today.



Everything is awesome!
Post #1398382
Posted Wednesday, December 19, 2012 7:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 6:01 AM
Points: 238, Visits: 123
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!
Post #1398407
Posted Wednesday, December 19, 2012 8:04 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:57 AM
Points: 542, Visits: 569
Good Question, learned something today.
Post #1398430
Posted Wednesday, December 19, 2012 9:55 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:25 PM
Points: 1,721, Visits: 1,198
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.

Thanks for the good question, apparently I really needed to learn that one.
Post #1398520
Posted Wednesday, December 19, 2012 10:37 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 3,786, Visits: 1,086
Thanks for the easy question.
Saludos,


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan
Post #1398551
Posted Wednesday, December 19, 2012 12:06 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:51 PM
Points: 4,386, Visits: 3,395
It was easy, but really good for getting back to the basics. Thanks!
Post #1398604
Posted Wednesday, December 19, 2012 8:47 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:57 PM
Points: 3,261, Visits: 1,954
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.
Post #1398751
Posted Thursday, December 20, 2012 2:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
from beginning............
Post #1398865
Posted Thursday, December 20, 2012 6:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Thanks for memorized .



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1398944
Posted Saturday, December 22, 2012 1:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 #1399662
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse