What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 18926 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
What are the key configuration files for sql server reporting services ?
Explain “row_number()” in sql server with an example?
What are the steps to follow to configure SQL*Net?
Why use identity in sql server?
What is apply operator in sql?
What is clustered index
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is a non equi join?
define and explain the differences between clustered and non-clustered indexes.
What are the properties and different types of sub-queries?
Can we use where clause with group by?
which backup strategy you are following at ur company
explain what is raid and what are different types of raid configurations? : Sql server database administration
What are the advantages of passing name-value pairs as parameters?
