Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79673 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / aastha pallav
Sometimes we need to know about the data which is being
inserted/deleted by triggers in database. With the
insertion and deletion of data, tables named “INSERTED”
and “DELETED” gets created in SQL Server which contains
modified/deleted data.
Here, “INSERTED” and “DELETED” tables are called magic
tables.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are the different types of backups avaialabe in sql server 2005?
Why I have to use stored procedures?
Explain about Views?
how can u get last observation in an unknown dataset ?
How do I find the size of a sql server database?
What is 2nf example?
What is sql language?
In case you have filters in your report, when filters will be applied in cached report instance?
Explain how to use linked server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain syntax for viewing, dropping and disabling triggers?
Why the trigger fires multiple times in single login?
What do you understand by recursive stored procedure?
How would you add a section to a table?
What are pessimistic lock and optimistic lock?
