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
What are points to remember while using the fillfactor argument?
List out the different types of locks available in sql server?
What is use of @@ spid in sql server?
What are unicode character string data types in ms sql server?
What is a livelock?
Where is localdb stored?
What is normalization? Explain its different types?
Write a SQL command to insert and update only a particular field?
Can we use having clause without group by?
How to create median function?
Explain different types of collation sensitivity?
How to modify an existing user defined function?
How to retrieve error messages using mssql_get_last_message()?
What is data block and how to define data block size?
What is pivot and unpivot?