Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19358 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
1.Both Truncate and Delete are rollbacked in TSQL.
2.Truncate maintains single record in Transaction log
entire records where Delete writes one-to-one record which
is slow in performance.
3.Truncate reinitializes the IDENTITY count to zero.
4.Truncate gives error with Table Variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are sub reports?
How many levels of sp nesting are possible?
What are out-of-range errors with date and time literals?
What is raiseerror? What is raiseerror?
What is the purpose of floor function?
Explain ranking functions?
What is a system database and what is a user database?
What command do we use to rename a database?
What is tablix?
What are the main sources of data?
What is table-valued sub query?
Explain what is lock escalation and what is its purpose?
Give me a SQL Query to find out the second largest company?
Explain the functionalities that views support?
Why we should not use triggers?
