Interested to Buy Any Domain ? << Click Here >> for more details...
wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 8339 Views
- Apollo, I also Faced
- E-Mail Answers
Answer Posted / rakesh
The Main Difference Between DELETE & TRUNCATE Are :-
[1] DELETE - is a DML Command & TRUNCATE - is a DDL Command
[2] After DELETE - can rollback the Records & After TRUNATE
- cannot rollback the records
[3] In DELETE Command you can give the conditions in WHERE
Clause & In TRUNCATE you cannot give conditions
[4] After using DELETE Command The memory will be occupied
till the user does not give ROLLBACK or COMMIT & After using
TRUNCATE Command The memory realeased immediately
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are all the different normalizations?
How do I view stored procedures?
what is the bond code in materialized view?
How to use boolean type in select statement?
What do you understand by pl/sql packages?
What is the difference between having and a where in sql?
What is a temporal data type?
what is table? : Sql dba
What is duration in sql profiler trace?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is Collation Sensitivity ? What are the various type ?
In a distributed database system, can we execute two queries simultaneously?
Are sql database names case sensitive?
Explain what is a field in a database and record in a database?
What is the use of nvl function?
