是说 你这个表设计的不合理 你的主表 应该设置个ID 然后子表记录这个id就可以了触发键 可以这么写CREATE TRIGGER [TRIGGER NAME] ON [dbo].[sysfiles1] FOR INSERT ASinsert into 子表
create trigger update on 表 a for delete as if @@rowcount=0 return delete 表 b where a.编号=( select b.编号 from b ) if @@error!=0 begin ROLLBACK TRAN return end RERURN go
使用触发器,上面写错了几个地方。 例如: create trigger delete on 表 a for delete as if @@rowcount=0 return delete 表 b where a.编号=(select b.编号 from deleted) if @@error!=0 begin ROLLBACK TRAN return end RERURN go
FOR INSERT
ASinsert into 子表
for delete
as
if @@rowcount=0
return
delete 表 b
where a.编号=( select b.编号 from b )
if @@error!=0
begin
ROLLBACK TRAN
return
end
RERURN
go
例如:
create trigger delete on 表 a
for delete
as
if @@rowcount=0
return
delete 表 b
where a.编号=(select b.编号 from deleted)
if @@error!=0
begin
ROLLBACK TRAN
return
end
RERURN
go