Answer Posted / yoshita
DML triggers use the deleted and inserted logical
(conceptual) tables. They are structurally similar to the
table on which the trigger is defined, that is, the table
on which the user action is tried. The deleted and inserted
tables hold the old values or new values of the rows that
may be changed by the user action. For example, to retrieve
all values in the deleted table, use
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is factless fact table? : sql server analysis services, ssas
What is advantage data architect?
What is the difference between primary key and unique constraints?
What is check constraint in sql server?
Are resultset updatable?
What is an index in sql?
Explain log shipping and mention its advantages.
What is cube dimension? : sql server analysis services, ssas
What is buffer cash and log cache in sql server?
How to set database to be single_user in ms sql server?
What is simple indexing method?
Detail about query optimizer?
Differentiate between a primary key and a unique key.
Describe the left outer join & right outer join. : sql server database administration
Is the log file is a part of file group?