What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
Tell me what is de-normalization and what are some of the examples of it?
What is query parameter in ssrs?
What is the difference between migration and upgradation in sql server?
What is the server name in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
What is an index in sql?
What are data regions?
Are semicolons required at the end of sql statements in sql server 2005?
What are the encryption mechanisms in sql server?
What is the maximum size of sql server database?
What is self contained scalar sub query?
How can we improve performance by using SQL Server profiler?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is normalization process?
What is replace and stuff function in sql server?