Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22132 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 differences between char and varchar in ms sql server?
Explain how to use linked server?
How many types of local tables are there in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
What is a non-clustered index?
Can two tables have the same primary key?
What is rolap and its advantage? : sql server analysis services, ssas
Explain difference between control flow and data flow?
Is a primary key unique?
Explain cursor as data base object?
What is the difference between a function and a stored procedure?
Explain the purpose of indexes?
Difference between group by clause and having clause in SQL?
How do you debug a procedure in sql server?
What is the difference between set and select?
