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

Answer Posted / kumar

Truncate will fail if the concerned table has foreign key
constraints while delete doesnt.

Is This Answer Correct ?    15 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change the name of a database user?

757


Explain in details security in SQL azure?

117


What is query parameter in ssrs?

132


What is data modification?

718


Can we create clustered index on composite key?

704


Explain transaction server isolation?

770


Explain the relational database management system (rdbms)?

797


What are the advantages of sql stored procedure?

799


What are the advantages of stored procedure in sql server?

668


Explain a differential backup?

766


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

841


what information is maintained within the msdb database? : Sql server administration

729


What is raid and what are different types of raid levels?

811


What is the cartesian product of the table?

740


How to connect of datebase with sql express.?

844