IF EXISTS ( SELECT 1 FROM [TABLE] WHERE (BinDate>@BinDate AND BinDate<@EndDate ) or (EndDate>@BinDate AND EndDate<@EndDate ) ) --出错处理 else insert ...
IF EXISTS ( SELECT 1 FROM [TABLE] WHERE (BinDate>=@BinDate AND BinDate<@EndDate ) or (EndDate>@BinDate AND EndDate<=@EndDate ) ) --出错处理 else insert ...
SELECT 1 FROM [TABLE]
WHERE (BinDate>@BinDate
AND BinDate<@EndDate
) or
(EndDate>@BinDate
AND EndDate<@EndDate
)
)
--出错处理
else
insert ...
SELECT 1 FROM [TABLE]
WHERE (BinDate>=@BinDate
AND BinDate<@EndDate
) or
(EndDate>@BinDate
AND EndDate<=@EndDate
)
)
--出错处理
else
insert ...