Can we rollback records deleted by a truncate statement?
Answer Posted / 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 View All Answers
What are the security related catalog views? : sql server security
What does dml stand for?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
List all types of constraints in sql server?
What is history table in sql server?
How to use column default values in insert statements in ms sql server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain what is cte (common table expression)?
How to list all user names in a database?
What is pivot and unpivot?
Explain features and concepts of analysis services?
What is 2nf normalization form?
Is mysql better than sql server?
Explain tables in SQL Azure?
What is difference between views and tables?