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


Please Help Members By Posting Answers For Below Questions

How do I find the sql server database version?

534


What is the bookmark lookup and rid lookup?

578


What are “lost updates”?

617


What is SQL Server?

663


What is 'write-ahead log' in sql server 2000 ?

629






What is unique key constraint?

634


Can a table be created inside a trigger?

566


What are the tools available in market as an alternative to sql server reporting services?

88


What is difference between joins and subqueries?

538


How do I find the port number for sql server?

506


What is clr ddl trigger?

552


Does any body please help me what question's have asked for SSRS in the interview?

1673


What does the update command do?

617


What is a field in a table?

582


What are the disadvantages of using querystrings to send data from one page to another?

588