27,580
社区成员
发帖
与我相关
我的任务
分享
--如果是修改Approve列,才begin
if Update(Approve)
BEGIN
SET NOCOUNT ON;
--如果旧表的CPPK 列是空的
if inserted.CPPK is null
INSERT INTO [GIS].[dbo].[PrjPermissions]
([UserPK]
,[ProjectID]
,[Permission]
,[StartDate]
,[EndDate]
,[Approver]
,[ApproveDate])
VALUES
(inserted.Applicant
,inserted.ProjectID
,inserted.Approve
,getdate()
,DATEADD(dd, 7, getdate())
,Respondent
,getdate())
END
Create Trigger TR_Update表1
on 表1
for update
begin
declare @oldAcloumn varchar(50)
declare @oldBcloimn varchar(50)
select @oldAcloumn = Acloumn,@oldBcloimn=Bcloimn from deleted
if @oldAcloumn= null
begin
insert into 表2 values()
end
if @oldBcloimn= null
begin
insert into 表3 values()
end
end