What is difference between TRUNCATE and DELETE statement
Answer Posted / hari
Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I find the sql server database version?
what's the maximum size of a row? : Sql server database administration
How do I make a resultset scrollable?
What is left outer join in sql server joins?
What is a with(nolock)?
What is the difference between join and inner join?
How can you check the version of sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
How can I create a report based on a query? : sql server management studio
What do mean by xml datatype?
Mention a few common trace flags used with sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Some queries related to SQL
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are the disadvantages of using the stored procedures?