34,838
社区成员




declare @OrderDateType varchar(10)
select @OrderDateType = 'mm'
if @OrderDateType = 'mm'
select *
from table1
where datediff(mm,DateAndTime,getdate()) =1
else if ...
....
declare @OrderDateType varchar(10)
select @OrderDateType = 'mm'
exec('select *
from table1
where datediff('+@OrderDateType+',DateAndTime,getdate()) =1')