if object_id('testan ') is not null
begin
drop trigger testan
end
go
create trigger testan on 药品库存表 for update\
as begin
if update(某个字段)
begin
print '记录已被修改'
end
end
alter trigger dbo.[test]
on 药品库存表
for update
as
print '记录已被修改'
go
alter 是修改 要用create