Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25182 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
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is difference between order by and group by?
Explain system scalar functions?
What are the functions in sql server?
What is raid? : SQL Server Architecture
What is the use of for clause?
What is an identity?
How to set database to be single_user in ms sql server?
Define synonym?
Explain what is meant by replication of database?
What is clustered vs nonclustered index?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to list all schemas in a database?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
