22,209
社区成员
发帖
与我相关
我的任务
分享
ALTER trigger [dbo].[tr_personnelrec_update]
on [dbo].[SectionTransfer]
for update
as
begin
declare @DeptId int,@PostID int,@PRID int
if update(NewDep) and update(postdep)
update p set DeptId=@DeptId,postID=@PostID from inserted i ,personnelrec p where PRID=@PRID and 关联条件
end
create trigger my_trig on SectionTransfer for update
as
begin
begin
declare @NewDep as int
declare @NewPost as int
select @NewDep = NewDep ,@NewPost = NewPost from deleted
if exists(select 1 from inserted where NewDep <> @NewDep or NewPost <> @NewPost)
update PersonnelRec set DeptID = i.NewDep ,PostID = i.NewPost from PersonnelRec p, inserted i where p.DeptID = @NewDep and p.PostID = @NewPost
end
end
create trigger my_trig on SectionTransfer for insert , delete , update
as
begin
if not exists(select 1 from inserted)
delete PersonnelRec from PersonnelRec p , deleted d where p.DeptID = d.NewDep and p.PostID = d.NewPost
else if not exists(select 1 from deleted)
insert into PersonnelRec select ....这里自己补上
else
begin
declare @NewDep as int
declare @NewPost as int
select @NewDep = NewDep ,@NewPost = NewPost from deleted
if exists(select 1 from inserted where NewDep <> @NewDep or NewPost <> @NewPost)
update PersonnelRec set DeptID = i.NewDep ,PostID = i.NewPost from PersonnelRec p, inserted i where p.DeptID = @NewDep and p.PostID = @NewPost
end
end