Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rollback records deleted by a truncate statement?
- 3 Answers
- 9001 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
Indexes are updated automatically is the full-text index also updated automatically?
what are the Prerequisites for Replication?
Describe different Processing Modes offered by SSRS?
Explain “not null constraint” in sql server?
Explain what is the function of sql server agent windows service?
What is for xml in sql server?
Which data type columns are the best candidates for full-text indexing?
What is bulkcopy in sql?
List the ways in which dynamic sql can be executed?
What is a trigger what are the advantages of trigger?
What are cursors and when they are useful?
What are commit and rollback in sql?
How does normalization work?
How will you go about resolving deadlocks?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
