if exists (select 1 from M where @kaishi between kaishi and jieshu or @jieshu between kaishi and jieshu) select 1
select case when (页面开始时间 between kaishi and jieshu) or (页面结束时间 between kaishi and jieshu) or (页面开始时间<=kaishi and 页面结束时间>=jieshu) then 1 else 0 end from 表M
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 1
select
case when (页面开始时间 between kaishi and jieshu)
or (页面结束时间 between kaishi and jieshu)
or (页面开始时间<=kaishi and 页面结束时间>=jieshu)
then 1 else 0 end
from
表M
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)