Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8869 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
How to insert a new row into a table with "insert into" statements in ms sql server?
What do you mean by authentication modes in sql server?
If user is owning any SQL Objects, can we drop that user
why would you call update statistics? : Sql server database administration
between cast and convert which function would you prefer and why?
How do you manipulate data?
What is built-in/administrator?
Can we update data in a view?
What is the beast way to write CTE in SQL Server ?
Which data type columns are the best candidates for full-text indexing?
What are the mathematical functions supported by sql server 2005?
What is statement level trigger?
Can you explain what are various ways to enhance the ssrs report?
How to change server name in sql server?
How many non clustered indexes there can be on table ?
