- 求一sql触发器刚才回答我试了一下不成功,可能是我没把问题说清楚
- 刚才回答我试了一下不成功,可能是我没把问题说清楚,
表A 表B
表A 有 name字段 和 y字段
表B 有 name字段
在asp页中表单提交数据,在添加 表A的name key 数据后,想让表B 插入和表A name相同的字段数据,
所以想建一个触发器,这个触发器应该加在表A的吧
这个触发器该如何写
最好是添加 删除 更新 的,
笨人刚学习,希望加一点注解,
- CREATE TRIGGER [DeleteA] ON [dbo].[A]
FOR DELETE
AS
delete from b where [name] in (selece [name] from deleted)
CREATE TRIGGER [InsertA] ON [dbo].[A]
FOR Insert
AS
insert b([name]) select [name] from inserted
CREATE TRIGGER [UpdateA] ON [dbo].[A]
FOR Update
AS
delete from b where [name] in (selece [name] from deleted)
insert b([name]) select [name] from inserted