Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24472 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
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What are the instances when triggers are appropriate?
What are user defined functions in ms sql server?
what is the difference between Tabular and Matrix report?
What is openxml in sql server?
What are rest-style architecture's?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is the primary use of the model database?
How to create user messages with print statements in ms sql server?
How does Report Builder support Analysis Services cubes?
What are data regions?
What were the latest updates to SQL Azure service?
What is apply operator in sql?
Who is the owner of a schema in ms sql server?
If we delete pack Spec what will be the status of pack Body ?
