Interested to Buy Any Domain ? << Click Here >> for more details...
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 options are available to audit login activity? : sql server security
What is resource db in sql server?
How does a profiler work?
Explain how you can configure a running aggregate in SSRS?
what's the maximum size of a row? : Sql server database administration
What is row-level compre?
What are the joins in sql server? : sql server database administration
How to loop through returning rows?
How many categories of functions based their return modes?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How can sql server instances be hidden? : sql server security
Differentiate between ms sql server reporting services vs crystal reports?
What do you understand by mirroring?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
