往视图插入数据的问题！急！

[shaowei1119]

视图的定义如下
SELECT dbo.tResBaseInfo.*, dbo.tResQCQuestionsInfo.QuestionType AS QuestionType,
dbo.tResQCQuestionsInfo.Difficulty AS Difficulty,
dbo.tResQCQuestionsInfo.NeedTime AS NeedTime,
dbo.tResQCQuestionsInfo.MediaPath AS MediaPath,
dbo.tResQCQuestionsInfo.MediaType AS MediaType,
dbo.tResQCQuestionsInfo.MediaCanUseTimes AS MediaCanUseTimes,
dbo.tResQCSingleChoice.Content AS Content,
dbo.tResQCSingleChoice.Options AS Options,
dbo.tResQCSingleChoice.Total AS Total,
dbo.tResQCSingleChoice.DeduckMark AS DeduckMark,
dbo.tResQCSingleChoice.RightKey AS RightKey
FROM dbo.tResBaseInfo INNER JOIN
dbo.tResQCQuestionsInfo ON
dbo.tResBaseInfo.ID = dbo.tResQCQuestionsInfo.ID INNER JOIN
dbo.tResQCSingleChoice ON
dbo.tResQCQuestionsInfo.ID = dbo.tResQCSingleChoice.ID


插入的sql语句为：
insert into vResFullQCSingleChoice values(
'TQS000000000000000',
NULL,
'',
'','','','','','','',1,
'00040005','','00110001','00180001','00120000',
'00130000',
'00020002','00010000',1,'','00050004',0,'',' He thinks that there won''t be enough sets for everybody.',
4,0,1)
总是出现错误：
服务器: 消息 213，级别 16，状态 5，行 1
插入错误: 列名或所提供值的数目与表定义不匹配。

可我数了几遍，应该没错呀

[愉快的登山者]

将视图中的*，改为具体列名，再试。

[I_wanttoknow]

不会涉及到多行吗

[zjcxc]

视图中不能插入数据啊

[friendliu]

在基本表中INSERT，视图就会有了

视图并没有涉及到所有基本表的字段，当你对视图INSERT时
并没有向所以的基本表的所有字段都INSERT了，所以就不能关联的上了
在视图上就无法看到刚刚INSERT的记录

[friendliu]

如果你的视图里包括了所以基本表的字段，也就可以对视图INSERT了