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


Please Help Members By Posting Answers For Below Questions

How would we use distinct statement? What is its use?

783


Explain how to use linked server?

738


How to select an exiting database using mssql_select_db()?

669


How do I perform an unattended install of sql server 2000?

755


What is the significance of master, tempdb and model databases?

704






What is sql injection? How to protect against sql injection attack?

733


What is a subquery in a select query statement in ms sql server?

805


What is the difference between nvl and nvl2?

715


what is memory-optimized nonclustered indexes

730


What functions can a view be used to performed?

794


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

632


What do you understand by sql server agent?

685


Can sql server 2016 run on windows 7?

678


What is transaction server distributed transaction?

719


What program is used to store the data source file?

671