What is the difference between truncate and delete statement?
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 checksum in sql server.........???
Delete duplicate rows without using rowid.
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the difference between join and inner join?
Define model database?
How to invoke a trigger on demand?
What is a periodical index?
How to set the current database in ms sql server?
What is tablix?
Which data type columns are the best candidates for full-text indexing?
How to use clusters?
What is used to replicate sessions between instances in coldfusion clusters?
What are the differences between triggers and stored procedures?
What is the purpose of update statistics and scope_identity() function?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication