What is difference between TRUNCATE and DELETE statement
Answer Posted / nageswarao
truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is sql server management studio? : sql server management studio
Can you explain powershell included in sql server 2008?
How to create function without parameter in sql server?
What is the return type of executeupdate ()?
What is the importance of concurrency control?
What is microsoft sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Can group functions be used in the order by clause in ms sql server?
How to create a dml trigger using create trigger statements?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
List out different types of normalizations in sql server and explain each of them?
What is clr ddl trigger?
How self join is different from outer join?
How do database indexes work?