Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23008 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 trace the traffic hitting a sql server? : Sql server database administration
What is the difference between rank and dense_rank?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the difference between dataadapter and datareader?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How column data types are determined in a view?
What is the difference between dropping a database and taking a database offline?
How to drop an existing user defined function in ms sql server?
Explain sub-query?
What is a matrix in ssrs?
how you can list all the tables in a database?
Explain trigger classes i.e. Instead of and after trigger?
Explain what you mean by 3 tier architecture.
Describe how to use linked server?
What are the aggregate and scalar functions?
