Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 20444 Views
- I also Faced
- E-Mail Answers
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
What is a print index?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is a data source or ds? : sql server analysis services, ssas
what is a transaction? : Sql server database administration
What is indexing in sql server with example?
Explain insert into select statement?
Difference between DELETE and TRUNCATE?
What do you mean by acid?
What is inner join in sql server joins?
How to get a list all databases on the sql server?
What is the use of tempdb? What values does it hold?
When do you think a developer should use sql server-based cursors?
Explain what are the events recorded in a transaction log?
In case you have filters in your report, when filters will be applied in cached report instance?
What is the use of toad or sqldbx.?
