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 )
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
How do I edit a procedure in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Does the order of columns in update statements matter?
Which are new data types introduced in sql server 2008?
What encryption security is available in sql azure?
Give a example to search fr a string in all stored procedure in sql server.
What is a dataset and what are the different types of datasets?
What is measure group, measure? : sql server analysis services, ssas
What method is used by the Command classes to execute SQL statements that return single values?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to attach adventureworkslt physical files to the server?
what happens on checkpoint? : Sql server database administration
What do you mean by an execution plan? Why is it used? How would you view it?
What authentication modes does sql server support?
Which tcl commands are available on the sql server?