Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8535 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / sreejith s t
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 ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is sql language?
Tell me the difference between clustered and non-clustered index?
What is a ddl statement?
What is difference between view and materialized view?
What are advantages of ssrs or why we should use ssrs?
How to start and end transact-sql statements?
What are the difference between primary key and unique key? : sql server database administration
What are constraints in microsoft sql server?
What are different types of replication in sql server?
How do I delete a sql server database?
Do you know what are the reporting services components?
What is the recovery model?
Explain contrast amongst grouped and non-bunched records?
Where are sql server usernames and passwords stored in the sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
