Learning Language Of SQL: A Beginners Guide Step By Step Training Performance Integration Services For Mere Mortals To Understand Database Design And Data Analytics And Computer Programming Server by Hack Phil J

Author:Hack, Phil J. [Hack, Phil J.]
Language: eng
Format: epub
Published: 2019-11-12T16:00:00+00:00

1

14

Suzana

Insert Operation

INSTEAD OF Trigger

In this section we will study INSTEAD OF Trigger. For instance, consider a scenario where you want to update price of different examinations. You also want to implement the condition that if price is less than 250, it should not be updated. Also, you want to keep track of all the efforts to update the price.

In such case you can use INSTEAD OF trigger to execute a script which checks If the updated price is less than 250 you, log entry in to the table that “price cannot be updated”, otherwise update the price and log the entry that “price updated”. The following example creates this INSTEAD OF trigger.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.