Can we rollback records deleted by a truncate statement?
Answers were Sorted based on User's Feedback
Answer / anand
yes,we can ROLLBACK records deleted by truncate if we had
executed BEGIN TRAN first
ex:
Begin Tran
truncate table tablename
ROLLBACK
with out "Begin Tran" you can not rollback
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / mp
No, because it is a DDL.
We can only rollback DML statements, right?
| Is This Answer Correct ? | 6 Yes | 9 No |
What is Self Join?
What are the benefits of using stored procedures over sql statements?
What is the difference RDBMS and Graph Database?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Which institute is best for SQL Server 2005 Training?
Can you insert NULL in unique column?
What is normalization? What number of normalization shapes are there?
What are the types of indexes?
How to encrypt data between dialogs?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
please differentiate between delete and truncate?
what is the difference between delete,drop and truncate
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)