Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22516 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 is single-user mode and what are the steps you should follow to start sql server in single-user mode?
what is an extended stored procedure? : Sql server database administration
What happens if null values are involved in bitwise operations?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What are different types of views?
Can a synonym name of a table be used instead of a table name in a select statement?
How to convert a unicode strings to non-unicode strings?
Why do we need normalization?
What is sub query and its properties?
what is the maximum size of a row? : Sql server database administration
How do I clean up sql server transaction log?
What are different types of database indexes?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is a transactions?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
