不把inserted里面的字段富裕变量@name等，直接通过inserted. medician_name 引用试试

我再试试，但是怎么显示无法绑定由多个部分组成的标识符 "medician.number"。

那个的话,是触发器引起的.
改变下顺序应该就可以了.

insert into 药库(medician_name,medician_store)output inserted.* values('感冒冲剂',1000);
insert into 药库 (medician_name,medician_store)output inserted.* values('阿司匹林',500);
insert into 药库 (medician_name,medician_store)output inserted.* values('斯达舒',1500);
insert into 药库(medician_name,medician_store) output inserted.* values('整肠生',1200);
insert into 入库清单  values('感冒冲剂','500g',300,'盒','15.0','4500',getdate(),'刘金宝','李金宝','汤唯','周','蔡')

是将插入的顺序修改一下吗？？ 但是是因为触发器的问题，无法同时插入吗

这样可以不

if object_id('Trigger1','TR')is not null
drop Trigger Trigger1;
go
create trigger Trigger1 on 入库清单
for 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
update 药库 set medician_store=medician_store+(select medician_number from inserted),
                修改日期=getdate()        
where medician_name =(select medician_name from inserted )
end
go

我先开始的初衷用insert不用update是为了，我想查某月某日的库存余量，可是改成update的话，我想不出来怎么做了

那就这样吧:

if object_id('Trigger1','TR')is not null
drop Trigger Trigger1;
go
create trigger Trigger1 on 入库清单
for 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 medician_name,medician_number,date from inserted
end
go

可是这样修改的触发器是将入库清单的数据照搬入药库呀，这样药库就没有意义了，没有办法显示库存了

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 修改日期 = (select top 1 修改日期 from 药库 where medician_name=@name order by 修改日期 desc)
end
go

引用:

想达到什么样的目的?

"where 修改日期 = (select top 1 修改日期 from 药库 where medician_name=@name order by
修改日期 desc) 我用这句话替换了先前的最后一句，

有些改善，可是还是不行，  -- 应该可以了.  -- 什么是有些改善,还是不行?


我想问的是这句话可不可以完成条件是指定药品离现在最近的一条记录 -- 可以.