Can we rollback records deleted by a truncate statement?
- 3 Answers
- 8050 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
Which Model uses the SET concept
Can truncate be rolled back?
How to list all field names in the result set using mssql_field_name()?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is key attribute?
Explain user defined views?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Why are you getting errors when creating a new odbc dsn?
What are the difficulties faced in cube development? : sql server analysis services, ssas
How to rename an existing column with sql server management studio?
What are the differences between stored procedure and view in sql server?
Find columns used in stored procedure?
Why we should not use triggers?
What are the options which must be set to allow the usage of optimistic models?
How do you check sql server is up and running?
