问题很明确？如何向这个视图增加数据呢？几番尝试最终得到正确的sql为：

CREATE TRIGGER Trig_INS_VIEW1 ON VIEW1

INSTEAD OF INSERT

AS

DECLARE @a INT

DECLARE @b INT

BEGIN

SET NOCOUNT ON

INSERT INTO Table1 SELECT b,c FROM inserted

select @a=(max(a)+1) from Table1

select @b=e from inserted

INSERT INTO Table2(a,e) VALUES (@a,@b)

END

上一页  [1] [2] [3]