What is difference between TRUNCATE and DELETE statement
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
Ms sql server index?
What is save transaction and save point?
How to use wildcard characters in like operations in ms sql server?
How do I know if localdb is running?
Explain the truncate command?
What is Extended user-defined?
Why use stored procedures in sql server?
What are the restrictions while creating batches in sql server?
What is transaction server explicit transaction?
What is a full text index?
What do you understand by mirroring and mention the advantages of the mirroring?
How to add more data to the testing table in ms sql server?
List out different types of normalizations in sql server and explain each of them?
What are scalar functions in sql?
How are the unique and primary key constraints different?