34,838
社区成员




declare @dt datetime
declare @sql varchar(200)
set @dt='2016-05-01'
set @sql='select * from mytable where rq='''+CONVERT(VARCHAR(10),@dt,120)+''''
exec(@sql)
declare @dt datetime
set @dt='2016-05-01'
EXEC('select * from mytable where rq='''+@dt+'''')
加上引号