34,576
社区成员
发帖
与我相关
我的任务
分享
drop table ccnt,ctst
go
create table ccnt(n int)
go
create table ctst(id int, x int)
go
insert ccnt select 0
insert ctst select 1,1
go
select * from ccnt
select * from ctst
go
create trigger tr on ctst for update
as
update ctst set x=x+1
update ccnt set n=n+1
go
create trigger tr1 on ctst for insert
as
update ctst set x=x-2
update ccnt set n=n+1
go
insert ctst select 2,20
select * from ctst
select * from ccnt
ALTER TRIGGER [dbo].[aaa] ON [dbo].[tb1]
FOR UPDATE
AS
begin
UPDATE tb1
SET ModiTime = GETDATE()
From Inserted
WHERE tb1.HR_No = Inserted.HR_No
and tb1.Stat_No = Inserted.Stat_No
UPDATE tb2
Set Password = Inserted.Password
From Inserted
WHERE tb2.HR_No = Inserted.HR_No
and Inserted.Password <> ''
and Inserted.Password is not NULL
-- end
end
ALTER TRIGGER [dbo].[bbb] ON [dbo].[tb1]
FOR INSERT
AS
begin
UPDATE tb1
SET InTime = GETDATE()
From Inserted
WHERE tb1.HR_No = Inserted.HR_No
and tb1.Stat_No = Inserted.Stat_No
IF NOT Exists(Select HR.HR_No From tb1 HR, Inserted Where HR.HR_No = Inserted.HR_No)
begin
UPDATE tb2
Set Password = Inserted.Password
From Inserted
WHERE tb2.HR_No = Inserted.HR_No
end
end