SQL语句提问

现有表  Term
结构如下

time1 time2 idterm
2009-2-15 2009-6-30 11
2009-9-10 2010-1-15 12

如果输入 2009-4-25 则应该取出idterm 11
如果输入 2009-12-5 则应该取出idterm 12

这个SQL该怎么写？

分少请见谅

---

SQL code:

select idterm from tb
where time1<=输入日期 and time2>=输入日期

---

SQL code:
declare @time datetime
set @time ='2009-4-25'
select top 1 * from term where time1<=@time and time2 >=@time

---

SQL code:
declare @time1 datetime,@time2 datetime
set @time1=..
set @time2=..
select idterm from tb where time between @time1 and @time2

---

case...when....then..

---

select idterm from tb
where time1 <=time2 and time2>=time1

---

引用

现有表  Term
结构如下

time1 time2 idterm
2009-2-15 2009-6-30 11
2009-9-10 2010-1-15 12

如果输入 2009-4-25 则应该取出idterm 11
如果输入 2009-12-5 则应该取出idterm 12

这个SQL该怎么写？

分少请见谅