if (@StartTime > @EndTime)
Set @EndTime = cast (convert (char , @ScheduleDate + 1 , 101)+' '+convert (char , @EndTime, 108) as datetime )
Else
Set @EndTime = cast (convert (char , @ScheduleDate , 101)+' '+convert (char , @EndTime, 108) as datetime )
Set @StartTime = cast (convert (char , @ScheduleDate , 101)+' '+convert (char , @StartTime, 108) as datetime )
这条语句中的Convert,Cast 的意思,作用