view update

CREATE OR REPLACE VIEW [Current Product List] AS
SELECT ProductID, ProductName, Category
FROM Products
WHERE Discontinued = No;

原文地址:https://www.cnblogs.com/kakaisgood/p/9002800.html