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
How to change the name of a database user?
Explain in details security in SQL azure?
What is query parameter in ssrs?
What is data modification?
Can we create clustered index on composite key?
Explain transaction server isolation?
Explain the relational database management system (rdbms)?
What are the advantages of sql stored procedure?
What are the advantages of stored procedure in sql server?
Explain a differential backup?
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?
what information is maintained within the msdb database? : Sql server administration
What is raid and what are different types of raid levels?
What is the cartesian product of the table?
How to connect of datebase with sql express.?