Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19087 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
How to create a scrollable cursor with the scroll option?
do you know how to configure db2 side of the application? : Sql server database administration
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain collation?
Can you roll back the ddl statement in a trigger?
What is xdr?
What is efficiency data?
List the various tools available for performance tuning?
How do indexes help, types?
Explain transaction isolation levels in sql server?
What is lookup override?
What is tablix?
How can I check if a view exists in a sql server database?
How do you Implement SSIS Packages in your Project?
Can I work with several databases simultaneously? : sql server management studio
