what is the difference between Delete and Truncate
Answer Posted / manoj pandey
Check following blog post for Difference Delete vs Truncate: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between truncate vs delete in mssql?
What is the simplest way to create a new database in ms sql server?
what data regions are and what are the different data regions?
Is truncate autocommit?
can an automatic recovery be initiated by a user? : Sql server administration
What are the hotfixes and patches in sql server?
Why we should not use triggers?
What are sql servers used for?
What are the different types of upgrades that can be performed in sql server?
What you can do to delete a table without the delete trigger firing?
What is the difference between varchar and varchar types?
Explain what is the difference between union and union all?
Is foreign key a primary key?
Can you explain different types of joins?
Write down the syntax and an example for create, rename and delete index?