如果一个视图只引用了一个表,且视图中的列都是直接引用表中的基础数据,则可以通过视图更改数据,包括 insert, update, delete.
USE OrderCenter
GO
CREATE TABLE dbo.SaleOrder
(
OrderNumber CHAR(20) NOT NULL,
CustomerNumber CHAR(20) NOT NULL,
InDate DATETIME NOT NULL,
LastEditDate DATETIME NULL
)
GO
Create View dbo.UV_SO AS
SELECT
OrderNumber,
CustomerNumber,
InDate
FROM dbo.SaleOrder WITH(NOLOCK)
GO
INSERT INTO dbo.UV_SO
(
OrderNumber,
CustomerNumber,
InDate
)
VALUES
(
'123456',
'abcd',
GETDATE()
)
UPDATE dbo.UV_SO
SET InDate = GETDATE()-1