SQL Query to SELECT record based to match Date And Time DataType Columns

Check this sample

declare @Schedules table (Name varchar(20), [Date] Date, [Time] Time)

insert into @Schedules
select 'Schedule1', '12/19/2012', '13:43:00'
union all
select 'Schedule2', '11/22/2012', '01:13:00'
union all
select 'Schedule3', '10/02/2012', '12:44:00'

select * from @Schedules
where [Date] = '12/19/2012' and [Time] = '13:43:00'