sql service 触发器,监控一个表有新数据插入时,把这条数据再插到另一个表
create trigger tri_Line on Line
for insert
as
begin
if (select count(1) from Line)=0
begin
print '未插入数据'
end
else
begin
insert into LineSubset(LineName)select LineName from inserted
end
end
或者
create trigger tri_Line on Line
for insert
as
begin
insert into LineSubset(LineName)
select LineName from inserted
end