declare @t datetime
declare @sql varchar(888)
select @t = getdate()
select @sql = 'select * from [test] where date1 <'''+convert(varchar(50),@t)+''''
print(@sql)
exec (@sql)
declare @sql varchar(888)
select @t = getdate()
select @sql = 'select * from [test] where date1 <'''+convert(varchar(50),@t)+''''
print(@sql)
exec (@sql)