Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22131 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 39 Yes | 6 No |
Post New Answer View All Answers
what is a transaction and what are acid properties? : Sql server database administration
what is the system function to get the current user's user id? : Sql server database administration
What is dml command?
What are the 2 types of classifications of constraints in the sql server?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What are the common performance issues in sql server?
What is full outer join in sql server joins?
Data table as parameter in sql server?
What stored by the tempdb ? : sql server database administration
Does partitioning ssd reduce performance?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can binary strings be converted into numeric or float data types?
How to make a remote connection in a database?
Can a table be created inside a trigger?
