Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22107 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
List the different normalization forms?
How can a user-defined datatype be created?
How to execute multiple stored procedures at one time in sql server?
Can we deploy SSRS reports on our personal website?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Explain an incremental backup?
Explain the third normal form(3nf)?
What stored by the master? : sql server database administration
Why people hate cursor?
What is shrink log file?
How to write character string constants or literals in ms sql server?
What is GUID in sql server?
What programming language would you use to create embedded functions in ssrs?
How do I completely remove sql server instance?
How to find related tables in sql server?
