Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25584 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 do you rename a table in sql server?
How to convert numeric expression data types by assignment operations?
How you can move data or databases between servers and databases in sql server?
How to delete duplicate rows in sql server?
What is create command?
What are the types of database recovery models?
Tell me what is the significance of null value and why should we avoid permitting null values?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Explain different types of lock modes in sql server 2000?
What is a partitioned view?
What is snapshot replication?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain database normalization?
Can one drop a column from a table?
Can you explain what is the use of custom fields in report?
