我看了 触发器就是如下CREATE TRIGGER [TRIGGER NAME] ON [dbo].[CKDA]
FOR INSERT, UPDATE, DELETE
AS
CREATE TRIGGER [TRIGGER NAME] ON [dbo].[SPKCDA]
FOR INSERT, UPDATE, DELETE
AS这是两个表的
FOR INSERT, UPDATE, DELETE
AS
CREATE TRIGGER [TRIGGER NAME] ON [dbo].[SPKCDA]
FOR INSERT, UPDATE, DELETE
AS这是两个表的
FOR INSERT
AS
DECLARE @spcode char(10)
DECLARE cur1 CURSOR FOR select code from spda
open cur1
FETCH NEXT FROM cur1
INTO @spcode
WHILE @@FETCH_STATUS = 0
BEGIN
insert into spkcda
select code,@spcode,0,0 from inserted
FETCH NEXT FROM cur1
INTO @spcode
END
close cur1
DEALLOCATE cur1
这个是CKDA的触发器 不晓得什么意思 我刚才有点着急 随便一点就复制了 不好意思 我是个数据库新手 请多多包涵
就遍历表 spda,并将 spda 的每条记录的 code
与插入 CKDA 的所有新记录构成新的记录集插入 spkcda