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

What are the types of subquery?

735


How can I tell if sql server is 32 or 64 bit?

707


What is the difference between delete and truncate statements?

746


What is the difference between row_number and dense_rank?

598


What is the sql server agent?

780






Tell me what is log shipping?

750


What is the difference between varchar and nvarchar datatypes?

759


What is the current pricing model of SQL Azure?

98


What are partitioned views and distributed partitioned views?

798


How to enter binary string literals in ms sql server?

820


What is molap and its advantage? : sql server analysis services, ssas

709


What is the difference between primary key and unique constraints?

669


How many types of schemas are there?

732


How do I create an extended event in sql server?

668


Where the sql logs gets stored? : sql server database administration

687