What are Magic Table?
- 34 Answers
- 73434 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
Are all views updatable ?
What is triggers in ms sql server?
Explain what is public role in sql server?
Mention the command used to rename the database.
What is a performance monitor?
What is a data source file?
What are the pre-defined functions in the sql server?
Explain “@@rowcount” and “@@error” in sql server?
How do I start and stop sql server?
What are synonyms?
How secure is sql server database?
What is enhanced database mirroring in sql server 2008?
Give an example of why you would want to denormalize a database
What is the difference between char, varchar and nvarchar?
What is merge replication?
