select  *  from  Tab_A where T >=开始时间 and T<=结束时间

------解决方案--------------------
between ..and ..

------解决方案--------------------
SQL code
where T between 开始时间 and  结束时间

------解决方案--------------------
先获取到开始时间，结束时间
假设你输入的是字符串@s,以逗号区分开始时间，结束时间，例如：'0:00,5:30'

select * from tab_a where  
cast(T as datetime) between case(left(@s , charindex(@s,',') - 1) as datetime) and cast(substring(@s , charindex(@s,',') + 1 , len(@s)) as datetime)