Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22664 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
Why we use trigger in sql server with example?
What new changes are being made in SQL Server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are group functions in query statements in ms sql server?
What is pivot and unpivot?
What is the need for indexing?
what authentication modes does sql server support? : Sql server database administration
Write a sql query to display the current date?
Why should we go for stored procedures? Why not direct queries?
When a primary key constraint is included in a table, what other constraints does this imply?
What do you mean by sql server agent?
Is sql server free?
How does a profiler work?
What is the cartesian product of table?
Explain indexed views?
