Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79575 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
Can group functions be used in the order by clause in ms sql server?
Explain syntax for viewing trigger?
What are the disadvantages of merge replication?
Can we use trigger new in before insert?
What are “unrepeatable reads”?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Why is normalisation important?
List some case manipulation functions in sql?
What is the fastest way to permanently delete a 1 million row table named customers?
How do I run a trace in sql server?
How to check status of stored procedure in sql server?
Explain the difference between HTTP and HTTPS in database?
Does sql server 2000 full-text search support clustering?
How can I get data from a database on another server?
What is the order in which the sql query is executed?
