Answer / pankaj kumar upadhyay

1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.

2)delete can roll back but truncate is not rollback.

3)Truncate is faster compare delete command.

4)delete is DML command while Truncate is DDL.

Answer / afzal_aziz

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

Answer / kapil

Delete: is a DML command.
Truncate: is a DDL command.

Delete & Truncate both can be rolled back.
Untill you have not commit transaction.

Answer / amita

Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.

Answer / saradhi

Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back

What is difference between order by and group by?

0 Answers  

How to loop through the result set with @@fetch_status?

0 Answers  

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

How to use clusters?

0 Answers   Amdocs,

What do you understand by triggers and mention the different types of it?

0 Answers  

logshipping is Any difference 2000 and 2005?

2 Answers  

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

Give an example of SQL injection attack ?

0 Answers   HAL,

What are the joins in sql server? : sql server database administration

0 Answers  

What do we have to check in database testing?

0 Answers  

What is a result set object returned by odbc_exec()?

0 Answers  

What is a hint?

0 Answers