--错误提示很明确了,这样改吧.CREATE TRIGGER my_trig on A
for insert,delete
as
if not exists(select Song_ID from deleted) --如果是新增
insert B(Song_ID,Song_info) select Song_ID,Song_info from my_trig a
where exists(select * from inserted where Song_ID=a.Song_ID)
for insert,delete
as
if not exists(select Song_ID from deleted) --如果是新增
insert B(Song_ID,Song_info) select Song_ID,Song_info from my_trig a
where exists(select * from inserted where Song_ID=a.Song_ID)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货