你要明白视图的定义,他是用来表示数据的查询关系的,所以只是支持Select不支持Update的
CREATE VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ] < view_attribute > ::=
{ ENCRYPTION | SCHEMABINDING | VIEW_METADATA }看看这个
CREATE VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ] < view_attribute > ::=
{ ENCRYPTION | SCHEMABINDING | VIEW_METADATA }看看这个
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货