Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78699 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
System variable and temporary variables
What is table constraint?
How to disconnect from a sql server using mssql_close()?
How do I find the sql server instance name?
How can I create a report based on a query? : sql server management studio
what is normalization? Explain different levels of normalization? : Sql server database administration
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How many triggers you can have on a table?
What does it mean to normalize a database and why would you do it?
What happens if strings are casted into wrong code pages in ms sql server?
How many databases can we create in a single server?
What is the most common trace flags used with sql server?
How can delete duplicate records in cte in sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
When I delete any data from a table, does the sql server reduce the size of that table?
