Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8832 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
How much memory that we are using in Logshipping Concept?
What is the order by used for?
How the authentication mode can be changed?
When would you use the stored procedures or functions?
How to throw custom exception in Stored Procedure?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How to retrieve error messages using mssql_get_last_message()?
What are transactions and its controls?
What are the hotfixes and patches in sql server?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are the different authentication modes in sql server?
Which sql server table is used to hold the stored procedure scripts?
How do you trace the traffic hitting a sql server?
What is the Main Difference between ACCESS and SQL SERVER?
What is difference between inner join and join?
