Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23038 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
Should you normalize audio?
How to insert multiple rows with one insert statement in ms sql server?
Explain about service Broker functions?
How to get the number of affected rows?
Is null in sql server?
What is database replication?
How many types of functions are there in sql server?
Can we linked SharePoint to a SQL database?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
which backup strategy you are following at ur company
What gets stored inside msdb database?
What is sql collation?
How to create new tables with "create table" statements in ms sql server?
How many instances per computer are there in sql server 2000?
