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 cascading parameters in ssrs reports?

212

Can select statements be used on views in ms sql server?

1001

Is BCNF better than 2NF & 3NF? Why?

1002

What is the concept of optimization?

989

What does COMMIT command do?

1006

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1040

Where cross join is used?

903

What is openrowset sql server?

1061

what is unique and xaml nonclustered index

995

Do you know what is blocking?

899

Explain error handling in ssis?

964

What is the purpose of object explorer and its features? : sql server management studio

1121

What are the security related catalog views? : sql server security

912

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

How can you stop stored procedures from recompiling?

848