What is the difference between truncate and delete statement?
Answer Posted / valarmathi
truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.
delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are recommended options to be used while using db mirroring? : sql server database administration
What are parameterized reports? What are cascading parameters in ssrs reports?
What is difference between Datepart() and Datename() in SqlServer?
What is snapshot parameter in ssrs?
How to execute a sql statement using odbc_exec()?
Explain what is it unwise to create wide clustered index keys?
What is difference between rollback immediate and with no_wait during alter database?
What are the authentication modes in sql server? How can it be changed?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Do you know what guidelines should be followed to help minimize deadlocks?
How will you monitor replication latency in transactional replication? : sql server replication
What is the difference between index seek vs. Index scan?
What is scrollable cursor?