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
- 12723 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
Explain what are sparse columns?
How to find which stored procedure is currently running in sql server?
What are differences in between sql server 2012 and sql server 2016?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
what are candidate key, alternate key and composite key? : Sql server database administration
what is a self join? Explain it with an example? : Sql server database administration
Explain database normalization?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is 3nf normalization form?
What are sql server functions?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to test odbc dsn connection settings?
What does select 1 mean?
why would you use sql agent? : Sql server database administration
what's sql server? : Sql server database administration
