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 @ 2:02 PM
Points: 32,834, Visits: 14,974
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, November 07, 2013 4:04 PM
Points: 42, Visits: 107
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: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
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: Tuesday, November 05, 2013 6:08 AM
Points: 1,076, Visits: 591
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 04, 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 04, 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: Friday, December 07, 2012 8:25 AM
Points: 540, Visits: 245
A good explanation on TRUNCATE vs DELETE can be found at http://www.mssqltips.com/tip.asp?tip=1080.
Post #813559
Posted Thursday, November 05, 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