CREATE TRIGGER [TRIG_Upd_Dep] ON [dbo].[department] FOR UPDATE AS Begin declare @Old_Dep nvarchar(20),@New_Dep nvarchar(20) Select @Old_Dep=系名称 From deleted Select @New_Dep=系名称 From inserted Update STU Set 系名称=@New_Dep Where 系名称=@Old_Dep End
CREATE TRIGGER [TRIG_Upd_Dep] ON [dbo].[department] FOR UPDATE AS Begin declare @Old_Dep nvarchar(20),@New_Dep nvarchar(20) Select @Old_Dep=系名称 From deleted Select @New_Dep=系名称 From inserted Update STU Set 系名称=@New_Dep Where 系名称=@Old_Dep End
FOR UPDATE
AS
Begin
declare @Old_Dep nvarchar(20),@New_Dep nvarchar(20)
Select @Old_Dep=系名称 From deleted
Select @New_Dep=系名称 From inserted
Update STU Set 系名称=@New_Dep Where 系名称=@Old_Dep
End
FOR UPDATE
AS
Begin
declare @Old_Dep nvarchar(20),@New_Dep nvarchar(20)
Select @Old_Dep=系名称 From deleted
Select @New_Dep=系名称 From inserted
Update STU Set 系名称=@New_Dep Where 系名称=@Old_Dep
End