http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL- Server-Why-is-T

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / afzal_aziz

Answer Posted / afzal_aziz

http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to use "begin ... End" statement structures in ms sql server?

1037

What is the rdl file?

138

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1017

Explain what are page splits? : SQL Server Architecture

1059

What is collation sensitivity?

1055

How optimize sql query with multiple joins in sql server?

898

Explain what is analysis service repository?

990

Do you know the isolation level that sql server support?

960

What are the differences between substr and charindex in sql server.

1109

What is merge?

1016

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1238

What happens to a trigger with multiple affected rows?

938

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

941

Do you know what is normalization of database? What are its benefits?

1117

How efficient you are in oracle and SQL server?

1150