Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22943 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
How to list all user names in a database?
How to perform backup for certificates in sql server? : sql server security
Can we use where clause with group by?
How to reaname table name without using sp_Rename in sql server..?
Explain trigger and its types?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is an indexed view?
What is side by side migration in sql server?
Explain transaction server consistency?
Do you know what are different types of replication in sql server?
What is snapshot replication?
how you can list all the tables in a database?
How would we use distinct statement? What is its use?
Can you create a logon trigger in sql server 2005 express edition?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
