After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback )
Answer Posted / saravanan p
When we delete the records using triggers only the deleted
records will be stored in deleted table.
But if we do delete using begin transaction, the deleted
records will be stored in transaction log file. We cannot
see it visually.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is optimistic concurrency?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Does group by or order by come first?
explain different types of constraints? : Sql server database administration
What is check constraint in sql server?
Does sql server use java?
Explain transaction server distributed transaction?
What is page in sql server?
What are translations and its use? : sql server analysis services, ssas
What are truncate options available in sql server? : sql server database administration
Define outer join in sql server joins?
Explain trigger classes i.e. Instead of and after trigger?
How can I get data from a database on another server?
What is page-level compression?
What is blocking?