Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rollback records deleted by a truncate statement?
- 3 Answers
- 8870 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
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is an expression in ms sql server?
What do you understand by replication in sql server?
What are the results of running this script?
What is merge?
What is data modeling and Reterminal integrity?
What is the optimization being performed in oracle and SQL Server?
How do you make a trace?
What is the purpose of forms?
What is forward - only cursors / read only cursor?
how you can deploy an ssrs report?
What is dimension table? : sql server analysis services, ssas
What is self contained scalar sub query?
What are various limitations of the views?
Explain collation?
