Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22121 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
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 ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is subquery? Explain the properties of a subquery?
What is database isolation in sql server? : sql server database administration
What are different types of data sources?
What is side by side migration in sql server?
What it means to be triggered?
What's new in sql management studio for sql server? : sql server management studio
How do indexes help, types?
What is temporal data type?
How to create view in stored procedure sql server?
What is inline variable assignment?
How do you migrate data from mssql server to azure?
What is bit data type?
Explain what is analysis service repository?
Explain DBCC?
What are the disadvantages of using querystrings to send data from one page to another?
