--第一句这样写 if datepart(hour,getdate()) not in (8,9,10,11) return
create trigger test on tablename for update as if datepart(hour,getdate()) not in (8,9,10,11) return ... go
只要你的逻辑没问题,当然可以写在一起:create trigger test on tablename for insert,update,delete as ...
我写了怎么不起作用啊,另外,这触发器执行了,在Sqlserver里怎么找不到啊
我写了怎么不起作用啊,另外,这触发器执行了,在Sqlserver里怎么找不到啊--------------------------------------如果开头是这句: if datepart(hour,getdate()) not in (8,9,10,11) return 那当然不起作用,现在是23点。这触发器执行了,在Sqlserver里怎么找不到啊——不明白,找什么
if datepart(hour,getdate()) not in (8,9,10,11) return
on tablename
for update
as
if datepart(hour,getdate()) not in (8,9,10,11) return
...
go
on tablename
for insert,update,delete
as
...
if datepart(hour,getdate()) not in (8,9,10,11) return
那当然不起作用,现在是23点。这触发器执行了,在Sqlserver里怎么找不到啊——不明白,找什么