sql触发器
1
CREATE TRIGGER customer_state
2ON Customers
22FROM INSERT,UPDATE
4AS
5UPDATE Customers
6SET cust_state=Upper(cust_state)
7WHERE Customers.cust_id=inserted.cust_id;
CREATE TRIGGER customer_state2
ON Customers22
FROM INSERT,UPDATE4
AS5
UPDATE Customers6
SET cust_state=Upper(cust_state)7
WHERE Customers.cust_id=inserted.cust_id;