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 ««12

Identity Crisis Expand / Collapse
Author
Message
Posted Thursday, October 29, 2009 10:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:42 AM
Points: 32,394, Visits: 16,703
I have added the truncate item to the explanation.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #810974
Posted Thursday, October 29, 2009 12:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 12, 2015 12:34 PM
Points: 43, Visits: 111
SanjayAttray (10/29/2009)
Damn. I missed the increment/seed part. Generally we used (1,1) for identity column and its (1,3) in the question.


That hit me, too...
Post #811081
Posted Friday, October 30, 2009 5:54 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:11 AM
Points: 654, Visits: 267
Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.
Post #811485
Posted Friday, October 30, 2009 7:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 31, 2015 7:57 AM
Points: 1,156, Visits: 598
VM-723206 (10/30/2009)
Damn, I knew how this would work, and noticed the increment 3 too. My mind kinda' swapped the DELETE and TRUNCATE. Chose 4.


Welcome to the party. Not as easy as 1 2 3 ...


What you don't know won't hurt you but what you know will make you plan to know better
Post #811604
Posted Wednesday, November 4, 2009 2:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 12:18 AM
Points: 26, Visits: 54
What is the Difference between Truncate Table and Delete Table
Post #813493
Posted Wednesday, November 4, 2009 6:28 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: Saturday, July 19, 2014 6:50 AM
Points: 540, Visits: 254
A good explanation on TRUNCATE vs DELETE can be found at http://www.mssqltips.com/tip.asp?tip=1080.
Post #813559
Posted Thursday, November 5, 2009 1:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 12:18 AM
Points: 26, Visits: 54
Thanx Dun
Post #814065
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse