Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18990 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
Tell me the difference between clustered and non-clustered index?
Where sql server usernames and passwords are stored in a sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What stored by the model?
Detail about query optimizer?
What stored procedure can you use to display the current processes?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is a mixed extent?
What is a non equi join?
How to get a list of columns in a view using the "sp_help" stored procedure?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is the command to change the recovery model?
How can sql injection be stopped? : sql server security
Characterize join and name diverse sorts of joins?
What are the properties of the transaction?
