关于触发器的问题

创建一个触发器，希望向入库清单中插入**后，药库相应改变，可是只有一种**可以实现不知道为什么
if object_id('Trigger1','TR')is not null
drop Trigger Trigger1;
go
create trigger Trigger1 on 入库清单
after insert
as
declare @number int,@name varchar(15);
select @number=medician_number,@name=medician_name from inserted
if(@name not in(select medician_name from 药库))
begin
insert into 药库(medician_name,medician_store,修改日期)
select @name,@number,date
from inserted
end
else
begin
insert into 药库
select @name,@number+medician_store,date
from inserted,药库
where @name=药库.medician_name and 修改日期=(select top 1
修改日期 from 药库 order by 修改日期 desc)
end
go
insert into 入库清单   values('斯达舒','500g',300,'盒','15.0','4500',getdate(),'刘金宝','李金宝','汤','周','蔡')

alter trigger Trigger1 on 入库清单
after insert
as
set nocount on
insert into 药库(medician_name,medician_store,修改日期)
select medician_name, 0, max(date) from INSERTED
where medician_name not in (select medician_name from 药库)
group by medician_name
update a set a.medician_store=a.medician_store+b.num, a.修改日期=b.md from 药库 a
inner join
(select medician_name, sum(medician_number) num, max(date) md from INSERTED group by medician_name) b
on a.medician_name=b.medician_name
set nocount off
go