Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / punit chauhan
whenever a trigger is fire in response to an insert, delete and update statement.
Two special tables create, these are the inserted and deleted tables, they are also referred as magic tables.
* whenever we insert any record into the table then trigger use inserted table.
* whenever we delete any record into the table then trigger use deleted table.
* whenever we update any record into the table then trigger use inserted and deleted tables.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Explain rdbms?
Explain transaction server explicit transaction?
How to create a trigger for insert only?
What is self join in sql server joins?
What is pivot and unpivot?
What are different types of roles provided by ssrs?
If a stored procedure is taking a table data type, how it looks?
What is coalesce in sql server?
When is the use of update_statistics command?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What do you understand by a stored procedure?
Write an sql query for deleting duplicate rows?
Tell me what do you understand by a view? What does the with check option clause for a view do?
What is set nocount on?
