sql一个表每日做更新。根据某一关键字段查找出修改的数据

sql一个表每日做更新。根据某一关键字段查找出修改的数据

IF Update(GroupJobNo)
begin
declare @OldNo nvarchar(30),@NewNo nvarchar(30)
select @OldNo=IsNull(GroupJobNo,'') from deleted
select @NewNo=IsNull(GroupJobNo,'') from Inserted

if (IsNull(@OldNo,'')<>'') and (IsNull(@OldNo,'')<>IsNull(@NewNo,''))
begin
update CT_Job set GroupJobNo=@NewNo where GroupJobNo=@OldNo
end
end;