union all視圖數據的操作
建立三個數據表（stock_2005,stock_2006,stock_2007)各數據表操作都有條件約束.
：
CREATE TABLE [dbo].[stock_2005] (
[mat_no] [varchar] (10) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[years] [varchar] (4) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[mat_qty] [decimal](18, 2) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[stock_2006] (
[mat_no] [varchar] (10) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[years] [varchar] (4) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[mat_qty] [decimal](18, 2) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[stock_2007] (
[mat_no] [varchar] (10) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[years] [varchar] (4) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL ,
[mat_qty] [decimal](18, 2) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[stock_2005] WITH NOCHECK ADD
CONSTRAINT [PK_stock_2005] PRIMARY KEY CLUSTERED
(
[mat_no],
[years]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[stock_2006] WITH NOCHECK ADD
CONSTRAINT [PK_stock_2006] PRIMARY KEY CLUSTERED
(
[mat_no],
[years]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[stock_2007] WITH NOCHECK ADD
CONSTRAINT [PK_stock_2007] PRIMARY KEY CLUSTERED
(
[mat_no],
[years]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[stock_2005] ADD
CONSTRAINT [DF_stock_2005_mat_qty] DEFAULT (0) FOR [mat_qty],
CONSTRAINT [CK_stock_2005] CHECK ([years] = 2005)
GO
ALTER TABLE [dbo].[stock_2006] ADD
CONSTRAINT [DF_stock_2006_mat_qty] DEFAULT (0) FOR [mat_qty],
CONSTRAINT [CK_stock_2006] CHECK ([years] = 2006)
GO
ALTER TABLE [dbo].[stock_2007] ADD
CONSTRAINT [DF_stock_2007_mat_qty] DEFAULT (0) FOR [mat_qty],
CONSTRAINT [CK_stock_2007] CHECK ([years] = 2007)
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
現建立視圖stock
select * from stock_2005
union all
select * from stock_2006
union all
select * from stock_2007
請問可否對視圖stock進行新增,修改，刪除操作?可以的，要如何操作.
[解决办法]
在视图里建instead of update--触发器就可实现视图更新
