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
- 12714 Views
- CarrizalSoft Technologies, iGate, I also Faced
- E-Mail Answers
Answer Posted / saravanan p
When we delete the records using triggers only the deleted
records will be stored in deleted table.
But if we do delete using begin transaction, the deleted
records will be stored in transaction log file. We cannot
see it visually.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to name query output columns in ms sql server?
What is the difference between Normalization and De-normalization?
What stored by the model? : sql server database administration
What is the datatype of rowid?
What is subquery? Explain the properties of a subquery?
What is difference between cte and view?
What are the new features of sql server 2008 r2 reporting service?
How to use subqueries with the in operators in ms sql server?
Which table keeps information about stored procedures?
Explain the use of containers in ssis?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Can we perform backup restore operation on tempdb?
What do you understand by mirroring?
Do you know what guidelines should be followed to help minimize deadlocks?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
