Can we rollback records deleted by a truncate statement?
- 3 Answers
- 7573 Views
- CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
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 |
How to create new tables with "select ... Into" statements in ms sql server?
How and why use sql server?
Why truncate is ddl command?
What is the difference between composite index and covering index?
How do you open a cluster administrator?
What is clustered vs nonclustered index?
If we use where clause in the left outer join then how the query would behave/act?
What is data mart? : sql server analysis services, ssas
Explain different types of self contained sub query?
What is sql server replication? : sql server replication
Describe in brief databases and sql server databases architecture.
How to disable a login name in ms sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
