What is the difference between truncate and delete statement?
- 6 Answers
- 6623 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.
delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is meant by datasource?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How to provide values to stored procedure parameters in ms sql server?
What are alternate keys?
Tell me about the approaches which you used to counter the DI problems.
What do you understand by a stored procedure?
How to create and drop temp table in sql server?
How can you hide the sql server instances?
Difference between DELETE and TRUNCATE?
What is the difference between substr and charindex in the sql server?
In which sql server version report builder introduced?
What is difference between clustered and non clustered index?
Do you know the different ddl commands in sql?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the different types of subquery?
