SQL 两个时间段不能重复语句

2024-09-06 16:50:05

 DECLARE @BeginDate datetime;

 DECLARE @EndDate datetime;

 set @BeginDate='2015-03-2'

 set @EndDate='2015-03-2'

 SELECT * FROM Table

 where

 (BeginDate between @BeginDate and @EndDate) or

 (EndDate between @BeginDate and @EndDate) or

 (@BeginDate between BeginDate and EndDate) or

 (@EndDate between BeginDate and EndDate)

 DECLARE @BeginDate datetime;

 DECLARE @EndDate datetime;

 set @BeginDate='2014-03-2'

 set @EndDate='2015-06-2'

 SELECT * FROM Table

 where

 @BeginDate<=Date and

 Date <=@EndDate

 order by Date

第一个是时间段和时间段

第二个是时间段和时间点

最新文章

热门文章