34,576
社区成员
发帖
与我相关
我的任务
分享
create table tb
(kaishi varchar(10),
jieshu varchar(10))
insert into tb
select '2012/05/02','2012/05/05'
declare @kaishi varchar(10)
declare @jieshu varchar(10)
set @kaishi='2012/05/01'
set @jieshu ='2012/05/04'
select 1 from tb where not (kaishi >@kaishi and kaishi>@jieshu or jieshu<@kaishi and jieshu<@jieshu)
select
case when (页面开始时间 between kaishi and jieshu)
or (页面结束时间 between kaishi and jieshu)
or (页面开始时间<=kaishi and 页面结束时间>=jieshu)
then 1 else 0 end
from
表M