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
- 12829 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 a functions and types in sql server?
What will be the maximum number of index per table?
Can truncate be rolled back?
Explain cdc and sql injection?
What is page-level compression?
What does the not null constraint do?
What is openrowset sql server?
Do you know the isolation level that sql server support?
What were the latest updates to SQL Azure service?
Differentiate between a primary key and a unique key.
Explain what is lock escalation and what is its purpose?
Can you force a query to use a specific index?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the most common trace flags used with sql server?
How to join two tables in a single query in ms sql server?
