ALTER TRIGGER Add_clunm_trigger
ON dbo.T_Question
FOR INSERT
AFTER <Data_Modification_Statements, , INSERT,DELETE,UPDATE>
AS declare @a_id char(10)
SET NOCOUNT ON;
declare cr cursor for select a.Q_ClassCode from inserted a
open cr
fetch cr into @a_id
while @@fetch_status = 0
begin
exec [add_id] @a_id,''
fetch cr into @a_id
end
close cr
DEALLOCATE cr
T_Question
END
GO
ON dbo.T_Question
FOR INSERT
AFTER <Data_Modification_Statements, , INSERT,DELETE,UPDATE>
AS declare @a_id char(10)
SET NOCOUNT ON;
declare cr cursor for select a.Q_ClassCode from inserted a
open cr
fetch cr into @a_id
while @@fetch_status = 0
begin
exec [add_id] @a_id,''
fetch cr into @a_id
end
close cr
DEALLOCATE cr
T_Question
END
GO
代码其实都很清楚的。楼主可以查下MSDN。自己搞懂比别人说效果更好。
第一个应该是个存储过程,往里传入字段名称和字段类型,然后向表S_Appraisalnote添加列。
第二个是个触发器,每插入一条数据,就取其中的Q_ClassCode字段内容,调用存储过程。
第三个写的不对,应该向T_Question插入数据,然后触发触发器。