sqlserver里怎么向视图里插入数据
Create table sc(sno char(8),
cno char(6),
grade Smallint,
year char(4),
primary key(sno, cno, year),
FOREIGN KEY(sno)REFERENCES s(sno)on delete cascade,
FOREIGN KEY(cno)REFERENCES course(cno)on delete cascade,
CHECK ((grade IS NULL) OR (grade BETWEEN 0 AND 100))
);
create view View_80 as select sno, cno,grade from sc where sc.grade>80 with check option
insert into View_80
values ('08300010','801',87)
报错为:
消息 515,级别 16,状态 2,第 127 行
不能将值 NULL 插入列 'year',表 'master.dbo.sc';列不允许有 Null 值。INSERT 失败。