Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77638 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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
Can we insert data into a view?
What is the difference between DATETIME2 and DATETIME?
What is the architecture of ms sql reporting service?
what are the disadvantages of cursors? : Sql server database administration
Why do we use stored procedures in sql server?
What do you mean by collation recursive stored procedure?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How you can change a cross join into an inner join?
how many no of arguments can be passed in procedures and functions
Can we call stored procedure in trigger?
What is difference between sql and sql server?
What are xml indexes?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is difference between unique and primary key?
List the different types of collation sensitivities in sql server?
