What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20196 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 an indexed view?
what is blocking? : Sql server database administration
Differentiate between truncate vs delete in mssql?
How to disconnect from a sql server using mssql_close()?
Can we perform backup restore operation on tempdb?
What are the essential components of sql server service broker?
What are the different normalization forms?
Which tcp/ip port does sql server run on? How can it be changed?
What is store procedure? How do they work? When do you use?
what is raid and what are different types of raid configurations? : Sql server database administration
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Can we add our custom code in ssis?
how will add additional conditions in sql?
Is INSTEAD OF trigger directly applicable to Table ?
What is the recovery model? List the types of recovery model available in sql server?
