declare @time datetime
declare @sql varchar(1000)
set @time = getdate()
set @sql = 'select * form x where inserttme= '''+convert(varchar(20),@time,120)+''''
Print @sql
declare @sql varchar(1000)
set @time = getdate()
set @sql = 'select * form x where inserttme= '''+convert(varchar(20),@time,120)+''''
Print @sql
2、日期两侧需要加单引号,动态SQL中一个单引号需要用两个表示