Can we rollback records deleted by a truncate statement?
- 3 Answers
- 7559 Views
- CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain important index characteristics?
what type of index will get created after executing the above statement? : Sql server database administration
Where can you add custom error messages to sql server?
What happens if date-only values are provided as date and time literals?
Why use identity in sql server?
Explain what is analysis service repository?
After removing a table from database, what other related objects have to be dropped explicitly?
What is database replication?
What are the difference between clustered and a non-clustered index?
What programming language would you use to create embedded functions in ssrs?
What is the temp table?
Who is the owner of a schema in ms sql server?
What is trace flag in sql server?
What is executereader?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
