Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22560 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / firoz shaikh
If identity is set on column and current identity col is 10
then if truncate and delete is done then for truncate
identity col will be 1 and for delete then it will be 11.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is denormalization and when would you go for it? : Sql server database administration
How do I start sql server 2016?
What protocol does sql server use?
What is faster join or union?
Can an entity have two primary keys?
How do I create a trace in sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
How to create a new schema in a database?
Explain in details security in SQL azure?
What is the current pricing model of SQL Azure?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What to check if a User database is locked?
Can we use trigger new in before insert?
Why use update_statistics command in sql server?
What is global temp table?
