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

Do you know concepts and capabilities of sql server?

1059

How to loop through result set objects using mssql_fetch_array()?

1076

how can a database be repaired? : Sql server administration

971

What is transaction server distributed transaction?

1054

Explain the steps to use transact-sql cursor?

1062

How to execute a sql statement using odbc_exec()?

1140

How to create new databases with "create database" statements?

1019

How to use values from other tables in update statements in ms sql server?

1117

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

958

What is the purpose of indexing?

1044

what are isolation levels? : Sql server database administration

991

List types of tables in SQL Azure?

126

Can we deploy SSRS reports on our personal website?

168

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

What is dbcc?

1135