查询满足数据库中两个时间字段的所有记录问题

baggiojmj

我在表A中设有两个时间字段(startdate和enddate)记录合同的起始和结束日期，现在页面上也输入开始时间和结束时间进行查询，SQL怎么写才把满足的条件所有的记录查出来？

michealhenry

满足什么条件？

baggiojmj

解决了
declare @b datetime
set @b= '2017-01-01'
declare @e datetime
set @e= '2017-12-01'     
Select * from 表　where (@b between StateDate and EndDate or @e between StateDate and EndDate)

wgfxman

declare @b datetime
set @b= '2017-01-01'
declare @e datetime
set @e= '2017-12-01'     
Select * from 表　where StartDate>=@b and EndDate <=@e

baggiojmj

哦，应当这样才全面
declare @b datetime
set @b= '2017-01-01'
declare @e datetime
set @e= '2017-12-01'     
Select * from 表　where
@b between StartDate and EndDate or @e between StartDate and EndDate or startdate>=@b and enddate<=@e