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
Explain the truncate command?
What is create statement?
What is a covered index?
How to convert numeric expression data types using the cast() function?
What is the difference between mysql and sql server?
What is a cube? : sql server analysis services, ssas
How to provide values to user defined function parameters?
How dts is used to extract, transform and consolidate data?
What is difference between aggregate and analytic function?
Explain cursor as data base object?
Why does sql studio use a single registered database repository? : sql server management studio
What is the maximum size of column in sql server?
What are the various editions of sql server 2017 that are available in the market?
Are resultset updatable?
How to use linked server?
