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
How can you manage sql azure security?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain transaction server explicit transaction?
Is it ok to shrink transaction log?
What number sorts of privileges are accessible in sql?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
how to do partition in sqlserver
A trigger can reference objects outside the current database? State true or false.
Does transparent data encryption provide encryption when transmitting data across the network?
What is Sqlpaging in SqlServer 2005 ?
What is check constraint in sql server?
Define master database?
How to change the password of a login name in ms sql server?
What is cross join in sql server joins?
What is the maximum size of sql server database?