What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20193 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / monal
Delete doesn't reset identity column seed if you have 1
identity column in the table.
Truncate resets identity column seed to the original value.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to create new tables with "select ... Into" statements in ms sql server?
Which are the important points to note when multilanguage data is stored in a table?
Which sql server table is used to hold the stored procedure scripts?
What are the essential components of sql server service broker?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are types of subqueries?
What is #temp and @table variable in SQL server?
Define compound operators?
How many ways to create table-valued functions?
can a table be moved to different filegroup? : Sql server administration
What is factless fact table? : sql server analysis services, ssas
What authentication modes does sql server support?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What do you understand by SQL*Net?
What is a unique key constraint?
