Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24461 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
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 ? | 9 Yes | 1 No |
Post New Answer View All Answers
How can I add Reporting Services reports to my application?
What are rows and columns?
What is candidate key with example?
How to find tables without indexes?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the difference between dbcc indexdefrag and dbcc reindex?
what are candidate key, alternate key and composite key? : Sql server database administration
What is deploy, process and build? : sql server analysis services, ssas
how to create “alternate row colour”?
Which data type columns are the best candidates for full-text indexing?
How to view existing indexes on an given table using sys.indexes?
How network traffic be reduced by using the stored procedure?
What are the different types of replication are there in sql server 2000?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Write a SQL query in order to merge two different columns into single column?
