Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8870 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / sreejith s t
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 ? | 6 Yes | 2 No |
Post New Answer View All Answers
How does index makes search faster?
How does clustered and non clustered index work?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Explain cross join or cartesian product in sql?
How to download microsoft sql server 2005 express edition?
Difference between report and query parameter. Why do we need different type of parameter?
How to Update from select query in sql server?
What is a heap?
How can we solve concurrency problems?
What is a database table?
What are the encryption mechanisms in sql server?
How do I setup a local sql server database?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Explain the third normal form(3nf)?
