create trigger tg on tb for insert as if exists( select 1 from tb t where exists( select 1 from inserted where 日期=t.日期) having count(1)>21) begin rollback tran raiserror('提示内容!',16,1) end go
create trigger tg on tb for insert as if exists( select 1 from tb t where exists( select 1 from inserted where 日期=t.日期) having count(1)>21) begin rollback tran raiserror('提示内容!',16,1) end go
for insert
as
if exists(
for insert
as
if exists(
select 1
from tb t
where exists(
select 1
from inserted
where 日期=t.日期)
having count(1)>21)
begin
rollback tran
raiserror('提示内容!',16,1)
end
go
for insert
as
if exists(
select 1
from tb t
where exists(
select 1
from inserted
where 日期=t.日期)
having count(1)>21)
begin
rollback tran
raiserror('提示内容!',16,1)
end
go