select * from O where datediff(hour,createtime,getdate()) between 0 and 24
go
create trigger tr_b on b
for insert,update
as
insert into c(cc)
select aa from inserted
go
create trigger tr_b on b
for insert,update
as
insert into c(cc)
select aa from inserted
for insert,update
as
insert into c(cc)
select v.aa from inserted v join b t on v.id=t.id
where v.aa<>t.aa
go
create trigger tr_b on b
for insert,update
as
insert into c(cc)
select aa from inserted