|_____________________|  a
     |______________|    b


|_________________|      a
         |____________|  b

      |_______________|  a
|____________|           b


|_________________| a
|_________________| b

   |____________|        a
|___________________|    b



DECLARE @t TABLE(d1 DATETIME,d2 DATETIME)
INSERT @t SELECT '2008.11.4 9:30' ,'2008.11.4 11:00'
UNION ALL SELECT '2008.11.4 14:00','2008.11.4 16:30'


DECLARE @d1 DATETIME,@d2 DATETIME
SELECT @d1='2008.11.4 12:00',@d2='2008.11.4 15:00'
SELECT * FROM @t 
    WHERE d2 BETWEEN @d1 AND @d2 OR d1 BETWEEN @d1 AND @d2 OR @d1 BETWEEN d1 AND d2 OR @d2 BETWEEN d1 AND d2

------解决方案--------------------
SQL code
DECLARE @FROMDATE DATETIME
DECLARE @TODATE DATETIME
SET @FROMDATE='2008-11-04 12:00'
SET @TODATE='2008-11-04 15:00'

CREATE TABLE #A (S_DATE DATETIME,C_DATE DATETIME)
INSERT INTO #A SELECT '2008-11-04 9:30','2008-11-04 11:00'
INSERT INTO #A SELECT '2008-11-04 14:00','2008-11-04 16:30'
INSERT INTO #A SELECT '2008-11-04 11:30','2008-11-04 12:30'

SELECT * ,(CASE WHEN @FROMDATE>S_DATE AND @FROMDATE<C_DATE THEN 'YES' ELSE 'NO' END) YES_NO
FROM #A
DROP TABLE #A

/***
2008-11-04 09:30:00.000    2008-11-04 11:00:00.000    NO
2008-11-04 14:00:00.000    2008-11-04 16:30:00.000    NO
2008-11-04 11:30:00.000    2008-11-04 12:30:00.000    YES