select cast(date + ' ' + time as datetime) from tb
select covert(varchar(18),cast(date + ' ' + time as datetime),131) from tb
declare @d varchar(20),@t varchar(20) set @d='2004-02-23' set @t='14:21:50'select convert(varchar(10),convert(datetime,@d),103)+':'+@t23/02/2004:14:21:50
declare @d varchar(20),@t varchar(20)
set @d='2004-02-23'
set @t='14:21:50'select convert(varchar(10),convert(datetime,@d),103)+':'+@t23/02/2004:14:21:50