Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8821 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 happens when converting big values to integers?
Do you know the policy based administration feature of sql server 2008?
Why truncate is ddl command?
Explain the difference between delete,drop and truncate in SQL Server?
How do I manually uninstall an instance of sql server 2016?
What is difference between inner join and join?
How to recover from sql injection? : sql server security
Is it possible to have clustered index on separate drive from original table location?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How do I make a resultset scrollable?
Explain indexed views?
Can you explain the disadvantages/limitation of the cursor?
What is a field in a table?
Where are stored procedures in sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
