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
- 12987 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 forward - only cursors / read only cursor?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is a view in sql?
Tell me what is the difference between locking and multi-versioning?
What is partition index in sql server?
Mention the differences between local and global temporary tables.
What is the sql case statement used for?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what is checksum in sql server.........???
Can you import Microsoft Excel data to SSRS?
How many non clustered indexes there can be on table ?
What are the types of sql server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are some examples of schemas?
what are constraints? : Sql server database administration
