Check following blog post for Difference Delete vs Truncate: http://sqlwith

what is the difference between Delete and Truncate

Question Posted / manoj pandey

4 Answers
8469 Views
CarrizalSoft Technologies, Geo Research Centre, I also Faced
E-Mail Answers

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 different types of schemas?

895

How to find table changes in sql server?

1053

explain what is raid and what are different types of raid configurations? : Sql server database administration

951

Explain the types of indexes.

1114

What is a mixed extent?

955

What is report rendering ?

149

What is difference between equi join and natural join?

970

How do you delete duplicate records in sql server?

996

What is the difference between having clause and where clause in sql server?

1033

how you can configure a running aggregate in SSRS?

184

what is the sql equivaent of the dataset relation object ?

1964

What are the differences between left join and inner join in sql server?

1042

How do I view a script in sql server?

980

Do you know the capabilities of cursors?

1077

How to create a trigger for insert only?

982