Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we rollback records deleted by a truncate statement?

Question Posted / mp

Answers were Sorted based on User's Feedback



Can we rollback records deleted by a truncate statement?..

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

Can we rollback records deleted by a truncate statement?..

Answer / sathwika

yes we can rollback the truncated records

Is This Answer Correct ?    2 Yes 2 No

Can we rollback records deleted by a truncate statement?..

Answer / mp

No, because it is a DDL.
We can only rollback DML statements, right?

Is This Answer Correct ?    6 Yes 9 No

Post New Answer

More SQL Server Interview Questions

How to execute a sql statement using mssql_query()?

0 Answers  

Explain multiserver query

0 Answers  

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

what is dbcc? : Sql server database administration

0 Answers  

Which institute is best for SQL Server 2005 Training?

6 Answers  




how many type of indexing in database?

0 Answers   IBM,

Different Types of Functions ?

2 Answers   Satyam,

How to name query output columns in ms sql server?

0 Answers  

What is a system database and what is a user database?

0 Answers  

What are transactions and its controls?

0 Answers  

what is denormalization? : Sql server database administration

0 Answers  

What is the concept of optimization?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories