Interested to Buy Any Domain ? << Click Here >> for more details...
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 )
- 3 Answers
- 12866 Views
- CarrizalSoft Technologies, iGate, I also Faced
- E-Mail Answers
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 table-valued sub query?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is TDS(Tabular Data Stream) Gateway?
what are the disadvantages of cursors? : Sql server database administration
Which database stores information about replication?
How can you fetch alternate records from a table?
What is the correct order of the logical query processing phases?
Define normalisation?
How to compare the top two records using sql?
How do I start and stop sql server?
What is the name of reporting services config file and what’s it’s used for?
What is difference statement and preparedstatement?
What is a mutating table error and how can you get around it?
What is sql view?
What is a cursor, index in sql?
