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
Can we use where clause in union?
What the class forname () does?
What is de-normalization and what are some of the examples of it?
Can you pass expressions to stored procedure parameters?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is bulkcopy in sql?
what is unique and xaml nonclustered index
Explain the disadvantages of cursors?
What are the three different part of rdl file explain them?
Explain the cursor lock types?
What is implicit mode in sql server?
How to run queries with sql server management studio express?
What are the differences between substr and charindex in sql server.
Find columns used in stored procedure?
Difference between group by clause and having clause in SQL?