sql - 具有两个日期参数的两个日期字段中的条件

Question

我在名为 From_Date 和 To_Date 的表中有一个 ID 字段和两个日期字段。我想根据日期条件选择这个日期。

ID From_Date   To_Date
1  2011-05-03  2011-05-28
2  2011-04-29  2011-05-10
3  2011-05-09  2011-05-20
4  2011-04-28  2011-05-09
5  2011-04-29  2011-05-19
6  2011-05-09  2011-05-09
7  2011-05-09  2011-05-09
8  2011-05-09  2011-05-09
9  2011-05-21  2011-05-21
10 2011-06-06  2011-06-06
11 2011-05-21  2011-05-28
12 2011-05-14  2011-05-28
13 2011-05-23  2011-05-24
14 2011-05-27  2011-05-27
15 2011-05-23  2011-05-24

现在我想要两个参数作为开始日期和结束日期的条件喜欢

@StartDate = '05/01/2011'
@EndDate = '05/10/2011'

当开始日期和结束日期参数之间的日期数组应该与 From_Date 和 To_Date 字段之间的日期数组进行比较时，我希望从这些参数输出

输出:

ID From_Date   To_Date
1  2011-05-03  2011-05-18
2  2011-04-29  2011-05-10
3  2011-05-09  2011-05-20
4  2011-04-28  2011-05-09
5  2011-04-29  2011-05-19
6  2011-05-09  2011-05-09
7  2011-05-09  2011-05-09
8  2011-05-09  2011-05-09

这在单个查询中是否可能而不是使用触发器或函数？

Answer 1

如果您想要获取所有From_Date 或To_Date 都在您的日期范围(@StartDate 和@EndDate) 之间的记录，那么这是简单的查询，例如:

SELECT * FROM TableName
WHERE (From_Date BETWEEN @StartDate AND @EndDate) OR (To_Date BETWEEN @StartDate AND @EndDate);