求一个关于时间比较的存储过程（急）

[theNull]

表VoxPath有字段LoginTimeFrom和LoginTimeTo，分别存储时间的起始和终止小时（例如，8和20）

如何取得当前服务器时间的小时（24小时制），判断它是否处于LoginTimeFrom和LoginTimeTo的整型数值内？ 如果在此范围内，则返回true，否则返回false。
请用存储过程，谢谢！

[lw1a2]

select * from VoxPath
where datepart(hh,getdate())>=LoginTimeFrom and datepart(hh,getdate())<=LoginTimeTo

[lxzm1001]

create proc test
as
begin
if select datediff(hh,LoginTimeFrom,LoginTimeTo)<=24
print 'true'
else
print 'false'
end

[OracleRoob]

create procedure sp_test
as
begin

declare @i int

set @i = datepart(hour,getdate())

if @i=LoginTimeFrom and @i<=LoginTimeTo
print 'true'
else
print 'false'
end
go

[xeqtr1982]

create table a(LoginTimeFrom int,LoginTimeTo int)
insert into a select 8,20
go

create proc aa
as

if exists(select 1 from a where datepart(hour,getdate()) between LoginTimeFrom and LoginTimeTo)
print 'true'
else
print 'false'

go

exec aa

drop table a
drop proc aa

[OracleRoob]

--改

create procedure sp_test
as
begin

declare @i int

set @i = datepart(hour,getdate())

if @i>=LoginTimeFrom and @i<=LoginTimeTo
print 'true'
else
print 'false'
end
go

[LouisXIV]

没有其他限制条件？？

create procedure sp_timecompare
as
declare @a varchar(10)
if datepart(hh,getdate()) between (select LoginTimeFrom from VoxPath) and (select LoginTimeTo from VoxPath)
set @a='True'
else
set @a='False'
select @a
go