K
Kizspy.me
Zoom
1
3
Rowlett Bikes 3974
Picture 7.1
Class: IA1901, SE1901, SE1902, SE1903, SE1904, SE1905
Practical Paper
4 of 4
Question 8:
Paper No: 1
Create a trigger named trgUpdateRequiredDate on the required_date column of the orders
table to ensure that required_date is not earlier than order_date. However, if the required_date
is valid, it will take effect, and the data will be updated.
For example, when the following statement is executed, the output will appear as shown in
the following figure:
UPDATE Orders
SET required_date="2016-01-01"
WHERE order_id = 9
select * from Orders where order_id = 9
+ 100%
Close
