Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25116 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 39 Yes | 6 No |
Post New Answer View All Answers
What is a livelock?
How to receive output values from stored procedures?
What are the events recorded in a transaction log?
How to drop an existing table with "drop table" statements in ms sql server?
Data table as parameter in sql server?
What are the different types of replication are there in sql server 2000?
What are the acid properties?
What is create statement?
How to change a login name in ms sql server?
How you can minimize the deadlock situation?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Difference between primary key and clustered index?
What is field in algebra?
What is policy management?
What is the difference between coalesce() & isnull()?
