Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9062 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
Do you know what are various aggregate functions that are available?
How many partitions a clustered index has by default in sql server 2012?
What is Federation and Federation Member?
What is a schema in ms sql server 2005?
What are the disadvantages of indexes?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is failover clustering overview?
Explain optimistic and pessimistic concurrency?
How to create an index on a view?
Disadvantages of the indexes?
Do you know the cursor types?
What is the difference between dropping a database and taking a database offline?
What is dbcc updateusage?
How will you hide an attribute? : sql server analysis services, ssas
What is normalization according to you and explain its different levels?
