create table test
(
ID bigint,
BeginTime DateTime,
EndTime DateTime,
CheckInTime DateTime,
Re varchar(250)
);
指定的日期 段
declare @BeginTime dateTime
declare @EndTime datetime现在要查询 在@BeginTime 和 @EndTime 内,与表Test 的beginTime 和EndTime 产生时间交集的数据我写的是
select * from Test where 1=1 And
(@BeginTime between BeginTime And EndTime
OR @EndTime between BeginTime And EndTime
Or BeginTime>=@BeginTime And EndTime<=@EndTime
) 请问下 还有数据遗漏吗?
(
ID bigint,
BeginTime DateTime,
EndTime DateTime,
CheckInTime DateTime,
Re varchar(250)
);
指定的日期 段
declare @BeginTime dateTime
declare @EndTime datetime现在要查询 在@BeginTime 和 @EndTime 内,与表Test 的beginTime 和EndTime 产生时间交集的数据我写的是
select * from Test where 1=1 And
(@BeginTime between BeginTime And EndTime
OR @EndTime between BeginTime And EndTime
Or BeginTime>=@BeginTime And EndTime<=@EndTime
) 请问下 还有数据遗漏吗?
from Test
where 1=1 And
BeginTime <= @EndTime and
EndTime >= @BeginTime