DELETE vs TRUNCATE Check: http://sqlwithmanoj.wordpress.com/2009/02/22/dif

Differencr Between DELETE and TRUNCATE?

Question Posted / manoj pandey

Answer Posted / manoj pandey

DELETE vs TRUNCATE
Check: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/

~Manoj

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the three different part of rdl file explain them?

168

Explain the difference between primary keys and foreign keys?

506

What the different topologies in which replication can be configured?

554

What do you mean by subquery?

577

What stored by the msdb? : sql server database administration

556

What are the different ways you can create databases in sql server?

563

List down some advantages of sql stored procedure?

548

How would you go about developing a ssrs report?

110

What is difference in performance between insert top (n) into table and using top with insert?

528

What is meant by referential integrity?

582

how to trace the traffic hitting a sql server? : Sql server database administration

1121

What are the benefits and tasks of object explorer? : sql server management studio

605

Explain different forms of normalization?

521

What are window functions in sql server?

508

Explain how does the report manager work in ssrs?

492