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 are sparse columns?
Difference between DELETE and TRUNCATE?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Write an sql query to find first weekday of the month?
How to create a stored procedure with a statement block in ms sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Where the sql logs gets stored? : sql server database administration
What stored by the tempdb ? : sql server database administration
What is store procedure?
Differentiate between mongodb vs. Sql server?
What is data source object?
What is the difference between left and right outer join?
What does executeupdate return?
What is a non clustered primary key?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?