declare @datetime1 datetime,
@datetime2 datetime,
@sql nvarchar(100)
set @datetime1='1900-9-9'
set @datetime2='2006-1-1'
set @sql=N'select * from mytable where createtime between @datetime1 and @datetime2'
exec sp_executesql @sql,
N'@datetime1 datetime,@datetime1 datetime,',
@datetime1,@datetime2
@datetime2 datetime,
@sql nvarchar(100)
set @datetime1='1900-9-9'
set @datetime2='2006-1-1'
set @sql=N'select * from mytable where createtime between @datetime1 and @datetime2'
exec sp_executesql @sql,
N'@datetime1 datetime,@datetime1 datetime,',
@datetime1,@datetime2
@datetime2 datetime
set @datetime1='1900-9-9'
set @datetime2='2006-1-1'
exec(select * from mytable where createtime between convert(datetime,@datetime1) and convert(datetime,@datetime2))