Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23037 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / hari
Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the cpu pressure?
How to rebuild indexes with alter index ... Rebuild?
Do you know the cursor optimization tips?
Can you edit the .rdl code associated with a linked report?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is normalization? Explain its different types?
How many types of triggers in sql server?
What is efficiency data?
What is the user of Primary key?
What is default constraint in ms sql server?
What are the difference between clustered and a non-clustered index?
How will you hide an attribute? : sql server analysis services, ssas
What is the difference between a "where" clause and a "having" clause?
Explain the truncate command? : SQL Server Architecture
What is a document index?
