Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19127 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
What is a data collection table?
What is a database in ms sql server?
what is an index? : Sql server database administration
What is a non-clustered index?
What is difference between temp table and cte?
Using the customer, and order table in northwind database, please write a query to produce xml?
What are exact numeric data types in ms sql server?
What are the character string functions supported by sql server 2005?
What is difference between unique and primary key?
How to populate a table in sql server?
What is the advantage of sql server?
Write a query to find 5th highest amount paid from the customer table.
what are isolation levels? : Sql server database administration
What is the architecture of ms sql reporting service?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
