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 are distributed partitioned views?
What is a DBMS, query, SQL?
How to convert a table data in XML format in sql server?
What is user defined stored procedures?
Is sql server 2016 free?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Tell me in brief how sql server enhances scalability of the database system?
What is data set in report?
How do you use a subquery to find records that exist in one table and do not exist in another?
Comment,Datatypes are unlimited
Explain the different index configurations a table can have?
what is the system function to get the current user's user id? : Sql server database administration
Explain how many types of relationship?
What is the difference between resultset and resultsetmetadata?
What is the use of stored procedure?