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 the steps to process a single select statement?
Explain indexes disadvantages?
Can we use custom code in ssrs?
can an order by clause be used in a creation of a view?
How to generate create view script on an existing view?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Tell me what is normalization? Explain different forms of normalization?
what is dbcc? : Sql server database administration
Explain the categories of stored procedure?
What is plan freezing?
How to disconnect from a sql server using mssql_close()?
How do we know if any query is retrieving a large amount of data or very little data?
Why use sub query in sql server and list out types of sub queries?
Explain what are various ways to enhance the ssrs report?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?