What are Magic Table?
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
What is order of B+tree?
How can a user-defined datatype be created?
How to view the error log for any specific instance? : sql server database administration
What is difference between index and primary key?
What is sql server locking?
What are the different editions available in sql server 2000?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the default system databases in sql server 2000?
What is difference between temp table and cte?
What is user defined datatypes and when you should go for them?
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 difference function and stored procedure?
What is table valued function and scalar valued functions?
Name few endpoints exposed by ssrs 2012?
Tell me the use of keyword with encryption. Create a store procedure with encryption?