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 use inner join in sql server?

1051

Is t sql the same as sql server?

918

Explain the different types of backups available in sql server? : sql server database administration

862

What is wide table?

882

What happens when transaction log is full?

868

Tell me what is the order in which the sql query is executed?

894

Explain system rowset functions?

935

What is the difference between the 2 operating modes of database mirroring?

1054

How do you clear a log file?

979

To which devices can a backup be created and where should these devices be located? : sql server management studio

962

What is left outer join in sql server joins?

965

What is normalization process?

1103

Explain aggregate functions?

1025

What does man by sql wildcard characters in sql server?

991

What do you understand by mirroring and mention the advantages of the mirroring?

1008