What are Magic Table?
Answer Posted / subbu
suppose if we write a trigger on the table on insert or
delete or update
on insertion of record into that table,
inserted table will create automatically by database,
on deletion of record from that table,
deleted table will create automatically by database,
This two tables inserted and deleted are called magic
tables.
Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
What is a collation?
How to insert and update data into a table with "insert" and "update" statements?
What languages bi uses to achieve the goal?
Define synonym?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is a natural primary key?
How to modify existing triggers using "alter trigger"?
What are the different normalization forms?
What are the advantages of using cte?
How to select some specific rows from a table in ms sql server?
What is xdr?
What is auditing in sql server?
Explain go command in sql server?
Explain different types of collation sensitivity?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date