set @sql1=@sql1+' and b.input_date>='+cast(@start_time as varchar)+' and b.input_date<='+cast(@end_time as varchar)+''或者:
set @sql1=@sql1+' and b.input_date>='+convert(varchar,@start_time)+' and b.input_date<='+convert(varchar,@end_time)+''
set @sql1=@sql1+' and b.input_date>='+convert(varchar,@start_time)+' and b.input_date<='+convert(varchar,@end_time)+''
这样对吗?
在存储过程里,对'不是很了解