34,837
社区成员
发帖
与我相关
我的任务
分享求一简单触发器.高手帮忙!
表A
NUM CLASS NAME
表B
ID NUM ADD
我想在表A中插入一个数据(NUM)同时在B中如果没有该数据(NUM)也插入一条.
应该怎样写????
NUM CLASS NAME
表B
ID NUM ADD
我想在表A中插入一个数据(NUM)同时在B中如果没有该数据(NUM)也插入一条.
应该怎样写????
...全文
请发表友善的回复…
发表回复
老宛 2004-09-03
- 打赏
- 举报
CREATE TRIGGER [TRg_in] ON [a]
FOR insert
AS
insert into b (num) select num from inserted where num not in(select num from 表b)
FOR insert
AS
insert into b (num) select num from inserted where num not in(select num from 表b)
yesterday2000 2004-09-03
- 打赏
- 举报
CREATE TRIGGER [TRI_in] ON [a]
FOR insert
AS
if (select b.num from inserted a,b b where a.num=b.num) is null
insert into b (num)
select num from inserted
FOR insert
AS
if (select b.num from inserted a,b b where a.num=b.num) is null
insert into b (num)
select num from inserted
