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
- 12722 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
Does the unique constraint create an index?
What is the full form of ddl?
How to optimize stored procedures in sql server?
What happens if we shrink log file in sql server?
What is a cache in ssrs?
What are system databases into sql server (2005/2008)?
What is a periodical index?
Do you know what is normalization of database? What are its benefits?
How do I create a partition table in sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are the Advantages of using CTE in sql server?
Can group by be used without aggregate functions?
What are different types of statement?
What is de-normalization and what are some of the examples of it?
When we should use @@error?
