What are Magic Table?
Answer Posted / puneet sharma
INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain the functionalities that views support?
what is difference between view and Dip.
How would you go about developing a ssrs report?
How to use “drop” keyword in sql server and give an example?
How to convert numeric values to integers in ms sql server?
What is reportserver and reportservertempdb ?
What is normalization 1nf 2nf 3nf?
Explain about SQL server 2005?
How important do you consider cursors or while loops for a transactional database?
What are Spatial data types in SQL Server 2008
What are the rules to use the rowguidcol property to define a globally unique identifier column?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to add a new dsn with the odbc driver for sql server?
How do you clear a log file?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)