Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate
- 4 Answers
- 8461 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / anil sharma
Delete command execute row by row and it can't reset any
identity column's value.
But using Truncate command it reset all table and Identity
column also.So truncate command is fast then delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the recovery models for a database?
Is it true, that there is no difference between a rule and a check constraint?
What are examples of triggers?
What is the difference RDBMS and Graph Database?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the default schema of your login session in ms sql server?
explain extended properties
Explain the types of indexes.
What is compound operators?
how we use window authentication connection with sql server.?
Describe in brief authentication modes in sql server.
What is sql stored procedure?
What is the use of for clause?
Define candidate key, alternate key, and composite key.
What is clustered vs nonclustered index?
