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

Explain the differences between oledb sql server, oledbdotnet provider?

550


What are dataproviders?

545


how we can fire event in databound coulm in datagfrid withot using button?

567


What are the parameters that control most of connection pooling behaviors?

509


What is the difference between Response.Expires and Reponse.ExpiresAbsolute?

535






What is the use of adodc?

523


What is the namespaces being used to access oracle database?

513


What is the full form of ado.net?

508


What is difference between ado and other data object?

463


What is ado.net architecture?

487


What is microsoft ole db provider for sql server?

475


What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

524


What are the advantage of ado.net?

515


How to check if the Dataset has records ?

529


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

522