What are Magic Table?
- 34 Answers
- 73433 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
How do I partition a table in sql server?
How can you append an identity column to a temporary table?
how to use DTS package in 2000,2005,2008 in sql server
Explain what is it unwise to create wide clustered index keys?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is the log shipping?
what is an index? : Sql server database administration
what is nonclustered index
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is meant by datasource?
Explain security with sql azure?
Explain primary key and foreign key constraints?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is field with example?
Define synonym?
