Select * From FloatTable where dateandtime >= @StartDateTime and dateandtime <=@EndDateTime group by dateandtime 这样写肯定没错把! 你的错误原因,字符串和日期没有办法叠加
dateandtime是日期时间型,必须用动态语句
Select * From FloatTable where dateandtime >=cast(@StartDateTime as varchar(40)) and dateandtime <=cast(@EndDateTime as varchar(40)) group by dateandtime --这样不行吗?
declare @StartDateTime datetime,@EndDateTime datetime declare @SQL nvarchar(500),@par nvarchar(100)set @StartDateTime=getdate() set @EndDateTime=getdate()set @SQL='Select * From FloatTable where dateandtime >=@StartDateTime and dateandtime <=@EndDateTime group by dateandtime' select @par='@StartDateTime datetime,@EndDateTime datetime' execute sp_executesql @sql,@par,@StartDateTime,@EndDateTime
set @SQL='Select * From FloatTable where dateandtime >=@StartDateTime and dateandtime <=@EndDateTime group by dateandtime'这样写还 有问题吗??
where dateandtime >= @StartDateTime and dateandtime <=@EndDateTime
group by dateandtime
这样写肯定没错把!
你的错误原因,字符串和日期没有办法叠加
--这样不行吗?
declare @SQL nvarchar(500),@par nvarchar(100)set @StartDateTime=getdate()
set @EndDateTime=getdate()set @SQL='Select * From FloatTable where dateandtime >=@StartDateTime and dateandtime <=@EndDateTime group by dateandtime'
select @par='@StartDateTime datetime,@EndDateTime datetime'
execute sp_executesql @sql,@par,@StartDateTime,@EndDateTime
set @SQL='Select * From FloatTable where dateandtime >=@StartDateTime and dateandtime <=@EndDateTime group by dateandtime'这样写还 有问题吗??