Can we rollback records deleted by a truncate statement?

Question Posted / mp

3 Answers
8736 Views
CarrizalSoft Technologies, United Healthcare, I also Faced
E-Mail Answers

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

What is log in sql server?

0 Answers

please differentiate between delete and truncate?

0 Answers

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers

Explain different backup plans?

0 Answers

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers

Explain having clause and where clause?

0 Answers

Can we call stored procedure in trigger?

0 Answers

what is a self join? Explain it with an example? : Sql server database administration

0 Answers

Different Types of Functions ?

2 Answers Satyam,

What is the use of stored procedure?

0 Answers

For more SQL Server Interview Questions Click Here