Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20447 Views
- I also Faced
- E-Mail Answers
Answer Posted / gk singh
truncate provide faster processing than delete because of
truncate does'n require transaction log uddation
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What are the results of running this script?
Create and insert into temp table in sql server?
what data regions are and what are the different data regions?
What are the different types of backups avaialabe in sql server 2005?
List all the types of user-defined functions?
What is truncate table?
What are the functions in sql server?
How many cores do I need for sql server 2016?
How does a profiler work?
what is the system function to get the current user's user id? : Sql server database administration
What is optimistic concurrency?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Explain the truncate command? : SQL Server Architecture
Explain the use of keyword with encryption. Create a store procedure with encryption?
Explain log shipping?
