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
- 8121 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 procedures used for?
What is the difference between sql and mysql?
What is java sql driver?
What are the qualities of 2nf?
What is an exception in pl/sql?
What is a temporal data type?
What is the most restrictive isolation level? : Transact sql
tell me about various levels of constraint. : Sql dba
What are the features of pl sql?
Explain scalar functions in sql?
How many types of sql are there?
what is 'mysqlshow'? : Sql dba
how to use in conditions? : Sql dba
What is cold data?
Is sql microsoft?
