尝试下这个,我这边OK的declare @begin varchar(20) declare @Sql_Time varchar(255) set @begin='2007-12-04' select @Sql_Time ='select * from PX_JL where ( cast('''+@begin+''' as datetime)> jl_pxltime and cast('''+@begin+''' as datetime) <jl_pxetime)' exec(@Sql_Time) return
declare @Sql_Time varchar(255)
set @begin='2007-12-04'
select @Sql_Time ='select * from PX_JL where ( cast('''+@begin+''' as datetime)> jl_pxltime and cast('''+@begin+''' as datetime) <jl_pxetime)'
exec(@Sql_Time)
return