Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19029 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
1.Both Truncate and Delete are rollbacked in TSQL.
2.Truncate maintains single record in Transaction log
entire records where Delete writes one-to-one record which
is slow in performance.
3.Truncate reinitializes the IDENTITY count to zero.
4.Truncate gives error with Table Variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain different forms of normalization?
How do I find the default sql server instance?
What is data compression? : sql server database administration
Explain something about security and SQL Azure?
what is the information that can be stored inside a bit column? : Sql server database administration
Are connections to sql server encrypted?
What is the difference between an index and a unique index?
What does the not null constraint do?
Can you explain what is the use of custom fields in report?
How do you set a trace flag in sql server?
Please explain what is “asynchronous” communication in sql server service broker?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Explain what stored procedure sp_replcounters is used for? : sql server replication
Can You Use Data Mining Models In Ssrs?
What is the template in sql?
