Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23006 Views
- CTS, I also Faced
- E-Mail Answers
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
Why olap is used?
What are xml indexes?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain a join?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Tell me in brief how sql server enhances scalability of the database system?
List out the differences between the clustered index and non-clustered index in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How do I find the query plan in sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How many databases instances are there in sql server 2000?
Can a function call a stored procedure in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
How do I connect to sql server database?
How to create a user name in a database?
