Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24474 Views
- I also Faced
- E-Mail Answers
Answer Posted / kapil
Delete: is a DML command.
Truncate: is a DDL command.
Delete & Truncate both can be rolled back.
Untill you have not commit transaction.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What happens if the update subquery returns no rows in ms sql server?
What are null values in ms sql server?
What does <> symbol mean?
what is database replication? : Sql server database administration
What is CTE in SQL
Difference between report and query parameter.
What is isnull() operator?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is the use of toad or sqldbx.?
How to create function with parameter in sql server?
What is trigger and different types of Triggers?
what is a transaction? : Sql server database administration
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Explain can SSRS reports Cache results?
What are the differences between clustered and non-clustered index?
