Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8537 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / vasu
Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is truncate table?
How do I connect to sql server database?
What is the template in sql?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Which is the main third-party tool used in sql server?
What is a hint?
Does transparent data encryption provide encryption when transmitting data across the network?
how would you troubleshoot blocking? : Sql server database administration
What is a covering index?
What is the difference between migration and upgradation in sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is 1nf normalization form?
Describe how to use linked server?
what are the core components of SSRS?
Do you know how to make remote connection in database?
