What is the Magic Tables in Sqlserver2000?

Answer Posted / ahmed kapasi

magic tables are used to get the values which are updated
from a DML statement in a trigger. for example if an update
statement is fired that time the new value goes to the
inserted table and old value goes to the deleted table, you
can fetch this values from this two tables if required.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are dcl commands?

508


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1640


Describe datareader object of ado.net with example.

511


What is the use of sqldatareader class?

479


What is ole2 format?

509






What is ado full form?

506


What is ado and rdo?

504


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

460


Which is the feature of ado.net?

530


Which object is used to add relationship between two Datatables?

579


How to add an aggregate column?

537


Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

560


What is ole db query?

527


What is the difference between statement and preparedstatement interface?

567


What are the advantages using ado.net?

539