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

Explain what is lock escalation?

0 Answers  

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

what is physical sort data and logical sort data in index?

2 Answers  

Explain what is the function of sql server agent windows service?

0 Answers  




What are different types of schemas?

0 Answers  

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

What are the differences between char and nchar in ms sql server?

0 Answers  

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

What are data files?

0 Answers  

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

How to test values returned by a subquery with the in operator?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories