Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25196 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankaj kumar upadhyay
1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.
2)delete can roll back but truncate is not rollback.
3)Truncate is faster compare delete command.
4)delete is DML command while Truncate is DDL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do you know the isolation level that sql server support?
What do you understand by integration services in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are the 10 characteristics of data quality?
Show Practically Sql Server Views are updatable?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is transaction server distributed transaction?
What is the need for indexing?
What is a sql join?
explain different types of constraints? : Sql server database administration
What is service broker?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are the three different part of rdl file explain them?
what are triggers? : Sql server database administration
