这个动态SQL语句要怎么执行呢?有参数的use Logsdeclare @MaxUsers int
declare @Querydate datetimeset @MaxUsers = 11
set @Querydate = getdate() ----外部变量,临时赋值
Exec ('select top ' + @MaxUsers + ' UserName From [Logs]
where datediff(day, '+ @Querydate +' ,addTime)=0 ')where datediff(day, '+ @Querydate +' ,addTime)=0 如果改为where datediff(day, getdate() ,addTime)=0 就对了,但问题是,我这个@QueryDate是传入的日期呀!
declare @Querydate datetimeset @MaxUsers = 11
set @Querydate = getdate() ----外部变量,临时赋值
Exec ('select top ' + @MaxUsers + ' UserName From [Logs]
where datediff(day, '+ @Querydate +' ,addTime)=0 ')where datediff(day, '+ @Querydate +' ,addTime)=0 如果改为where datediff(day, getdate() ,addTime)=0 就对了,但问题是,我这个@QueryDate是传入的日期呀!
where datediff(day, '''+ @Querydate +''',addTime)=0 ')
use Logsdeclare @MaxUsers int
declare @Querydate datetimeset @MaxUsers = 11
set @Querydate = getdate() ----外部变量,临时赋值
Exec ('select top ' + @MaxUsers + ' UserName From [Logs]
where datediff(day, '''+ @Querydate +''',addTime)=0 ')
declare @MaxUsers int
set @MaxUsers = 11
set @Querydate = getdate() ----外部变量,临时赋值
print ('select top ' + cast(@MaxUsers as varchar(10)) + ' UserName From [Logs]
where datediff(day, '+ '''' + convert(varchar(10),@Querydate,120) +'''' +' ,addTime)=0 ')--where datediff(day, '+ @Querydate +' ,addTime)=0
select top 11 UserName From [Logs]
where datediff(day, '2006-05-12' ,addTime)=0