Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22557 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / manub22
–> DELETE:
1. Removes Some or All rows from a table.
2. A WHERE clause can be used to remove some rows. If no WHERE condition is specified, all rows will be removed.
3. Causes all DELETE triggers on the table to fire.
–> TRUNCATE:
1. Removes All rows from a table.
2. Does not require a WHERE clause, so you can not filter rows while Truncating.
3. IDENTITY columns are re-seeded on this operation, if no seed was defined then the default value 1 is used.
4. No Triggers are fired on this operation because it does not operate on individual rows.
Check more differences b/w DELETE & TRUNCATE here: http://sqlwithmanoj.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List some advantages and disadvantages of stored procedure?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What are the new features of sql server 2012 reporting service?
What is the distinction amongst delete and truncate?
How to override dml statements with triggers?
How can I create a report based on a query? : sql server management studio
What is collation sensitivity? Explain different types.
Which are new data types introduced in sql server 2008?
What is intellisense?
What do you mean by sql server agent?
What does nvl stand for?
What is sqlservr.exe - process - sql server (sqlex?press)?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are the advantages of using cte?
How to create prepared statements using odbc_prepare()?
