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
- 12860 Views
- CarrizalSoft Technologies, iGate, I also Faced
- E-Mail Answers
Answer Posted / nagesh
wen we are performing DML operations into table . 2 magic
tables created in the memory i.e., in Master Database.
Names of the 2 tables
1) INSERTED
2) DELETED
When we insert any record then that record will be added
into this Inserted table initially, similarly while
updating a record a new entry will be inserted into
Inserted table & old value will be inserted into Deleted
table.
In the case of deletion of a record then it will insert
that record in the Deleted table
when we call rollback command the deleted record retrieved
from Deleted table. Once committed we can't call rollback.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is the difference between a check constraint and a rule?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is ms sql server index?
Explain the categories of stored procedure?
How do you send email on SQL Server?
Tell me can we use custom code in ssrs?
How do I make a resultset scrollable?
Can you please explain the difference between primary keys and foreign keys?
What is bcp? When does it used?
What is the command to change the recovery model?
What is the difference between dropping a database and taking a database offline?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Are all views updatable ?
How many replicas are maintained for each sql azure db?
What are information schema views?
