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 is the federation in sql azure?

What is similarity and difference between truncate and delete in sql?

1086

Explain what is log shipping?

1129

How do you use a subquery to find records that exist in one table and do not exist in another?

1041

What does man by sql wildcard characters in sql server?

1050

Describe and explain about SQL native client?

1097

How to create a trigger for insert only?

1030

What is key set driven?

944

Can we shrink data file in sql server?

1035

When you should use a low fill factor?

987

Are connections to sql server encrypted?

996

Explain log shipping and mention its advantages.

1035

How to make remote connection in database?

1000

Explain nested join?

969

How do I create a partition table in sql server?

1098