Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate
- 4 Answers
- 8709 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Delete command execute row by row and it can't reset any
identity column's value.
But using Truncate command it reset all table and Identity
column also.So truncate command is fast then delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are Row versions of DataRow?
When would you use a before or after trigger?
Explain the use of containers in ssis?
Which tcp/ip port does the sql server run on? How can it be changed?
Do you know the isolation level that sql server support?
What is rtm version in sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to send email from database?
What is the difference between varchar and varchar(max) datatypes?
Does partitioning improve performance?
What is report server project?
Why use identity in sql server?
What is normalization? Describe its different types.
Does index slows down insert statements?
