create trigger tr_BoatRes on BoatRes for insert as begin if exists(select 1 from BoatRes a group by startdate,enddate having count(1)>1) begin rollback tran raiserror('startdate和enddate与其他纪录有重合.',18,18) end end
建议用唯一索引实现,create unique index ix_BoatRes_startdate_enddate on BoatRes(startdate,enddate)
create trigger tr_BoatRes on BoatRes
for insert
as
begin
if exists(select 1
from BoatRes a
group by startdate,enddate
having count(1)>1)
begin
rollback tran
raiserror('startdate和enddate与其他纪录有重合.',18,18)
end
end