SET @SQLSTR = 'SELECT TOP 100 from T_Table1 where publishTime between '+convert(varchar(100), @StartTime,23) '+ ' and '+ convert(varchar(100), @OverTime,23)
传入参数后总是无法返回记录,请问是什么问题啊
------解决方案--------------------
SET @SQLSTR = 'SELECT TOP 100 from T_Table1 where publishTime between ' ' '+convert(varchar(100), @StartTime,23)+ ' ' ' and ' ' '+ convert(varchar(100), @OverTime,23)+ ' ' ' '
------解决方案--------------------
declare @StartTime datetime
declare @OverTime datetime
set @StartTime= '2007-1-1 '
set @OverTime= '2007-4-1 '
declare @SQLSTR nvarchar(4000)
------------------------------------------------
SET @SQLSTR = 'SELECT TOP 100 * from T_Table1 where convert(varchar(100), Convert(datetime,publishTime),23) between ' ' '+ convert(varchar(100), @StartTime,23)+ ' ' ' and ' ' '+convert(varchar(100), @OverTime,23)+ ' ' ' '
------------------------------------------------
print @SQLSTR