Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22405 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 is the purpose of forms?
Explain about SQLOS?
What do you mean by a Composite primary key?
Using the customer, and order table in northwind database, please write a query to produce xml?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Can we update data in a view?
What is a self join in sql server?
What is the stuff and how does it differ from the replace function?
Which tools are available to manage SQL Azure databases and servers?
How do I run a trace in sql server?
What is optimistic concurrency?
What is the need for group functions in sql?
Can sql servers linked to other servers like oracle?
How to change a login name in ms sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
