Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8864 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 relationship? What number of sorts of relationship are there?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is raiseerror? What is raiseerror?
Explain the difference between clustered and non-clustered index?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What do you mean by stored techniques? How would we use it?
What is the filtered index?
How to turn on the mssql api module in php?
What is raid and what are different types of raid levels?
What happens if the update subquery returns multiple rows in ms sql server?
How to backup SQL Server Reporting Services ?
What's new in sql management studio for sql server? : sql server management studio
How do I create a partition table in sql server?
How to download and install sql server 2005 books online?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
