sql触发器
1![]()
CREATE TRIGGER customer_state
2![]()
ON Customers
22![]()
FROM INSERT,UPDATE
4![]()
AS
5![]()
UPDATE Customers
6![]()
SET cust_state=Upper(cust_state)
7![]()
WHERE 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;
浙公网安备 33010602011771号