<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>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<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
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by dun
»
Identity Crisis
17 posts, Page 2 of 2
««
1
2
Identity Crisis
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, October 29, 2009 10:26 AM
SSC-Dedicated
Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406,
Visits: 13,722
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
ck9663
ck9663
Posted Thursday, October 29, 2009 12:09 PM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, November 06, 2012 3:50 PM
Points: 34,
Visits: 91
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
VM-723206
VM-723206
Posted Friday, October 30, 2009 5:54 AM
SSChasing Mays
Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649,
Visits: 263
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
BudaCli
BudaCli
Posted Friday, October 30, 2009 7:59 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046,
Visits: 573
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
rizwan.inam
rizwan.inam
Posted Wednesday, November 04, 2009 2:37 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, October 04, 2012 10:20 PM
Points: 26,
Visits: 53
What is the Difference between Truncate Table and Delete Table
Post #813493
dun
dun
Posted Wednesday, November 04, 2009 6:28 AM
Mr 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
rizwan.inam
rizwan.inam
Posted Thursday, November 05, 2009 1:11 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, October 04, 2012 10:20 PM
Points: 26,
Visits: 53
Thanx Dun
Post #814065
« Prev Topic
|
Next Topic »
17 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
