wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
- 3 Answers
- 7411 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
Does google use sql?
What is the maximum number of columns in sql table?
What is lexical units in pl sql?
What is sorting in sql?
what is sub-query? : Transact sql
What are the different datatypes available in PL/SQL?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is the purpose of the sql select top clause?
What is the difference between jpql and sql?
Why do we need unique key in a table?
What is the difference between function and procedure in pl/sql?
What is a sql statement?
Which is better varchar or nvarchar?
What is AUTH_ID and AUTH_USER in pl/sql ?
What is the use of index in hive?
