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
- 12840 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 language is sql server written in?
How to set a database state to offline in ms sql server?
what are different types of raid configurations? : Sql server database administration
What is de-normalization and what are some of the examples of it?
What do you understand by a view? What does the with check option clause for a view do?
how to avoid cursors? : Sql server database administration
What is the command to change the recovery model?
What are data driven subscriptions?
How global temporary tables are represented and its scope?
How to rebuild indexes with alter index ... Rebuild?
What is the use of =,==,=== operators?
What is log in sql server?
What are the essential components of sql server service broker?
What are sub reports?
What is difference between index and primary key?
