你的触发器只针对更新一条记录有效,如果同时更新多条记录:
CREATE TRIGGER [bed_statuts_update] ON [dbo].[zy_bed_mi]
FOR UPDATE
AS
update zy_actpatient
set bed_charge_date = convert(datetime,convert(char(18),getdate(),121),121)
from zy_actpatient A
join deleted D on A.patient_id=D.patient_id
join inserted I on D.patient_id=I.patient_id and A.admiss_times=I.admiss_times
where D.old_bed_status='6' and
I.new_bed_status='2'
CREATE TRIGGER [bed_statuts_update] ON [dbo].[zy_bed_mi]
FOR UPDATE
AS
update zy_actpatient
set bed_charge_date = convert(datetime,convert(char(18),getdate(),121),121)
from zy_actpatient A
join deleted D on A.patient_id=D.patient_id
join inserted I on D.patient_id=I.patient_id and A.admiss_times=I.admiss_times
where D.old_bed_status='6' and
I.new_bed_status='2'
这个触发器的用途是这样的,当床位状态从6变为2时,给置上当前整理床位的时间。
求各位帮忙哦