Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23395 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nirmala.s
if u use delete to remove the data from the table,this will
delete the data.after using rollback the removed data can
be retrived.But in case of, truncate , it will delete the
data and that can't ever be retrived.even after using
rollback also. but the table structure of the table will
be there
if u are using drop command , this will delete entire
table.and its structure.
| Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
What does sql server mean?
What is sub-query in sql server?
What happens if we shrink log file in sql server?
What is the difference between functions and stored procedures?
What is an execution plan? How would you view the execution plan?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain what is the difference between a local and a global temporary table?
what are the different stages of Report Processing?
What is the largest component inside a field?
Do you think BCNF is better than 2NF & 3NF? Why?
What is the use of builtinadministrators group in sql server? : sql server security
Explain the properties of a relational table?
What is policy management?
What is difference between rollback immediate and with no_wait during alter database?
Why would you call update statistics?
