declare @starttime datetime
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31'exec(' select ItemBH from Xfjd_check where Date_Created not between '+@starttime+' and '+@finishtime+' ')
这句怎么就错了
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31'exec(' select ItemBH from Xfjd_check where Date_Created not between '+@starttime+' and '+@finishtime+' ')
这句怎么就错了
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31' declare @sql varchar(4000)
set @sql = ' select ItemBH from Xfjd_check where Date_Created not between '+@starttime+' and '+@finishtime+' '
exec(@sql)
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31'exec(' select ItemBH from Xfjd_check where Date_Created not between '''+@starttime+''' and '''+@finishtime+'''')
where Date_Created not between @starttime AND @finishtime',
N'@starttime DATETIME,@finishtime DATETIME',
@starttime,@finishtime;
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31' declare @sql varchar(4000)
set @sql = ' select ItemBH from Xfjd_check where Date_Created not between '''+convert(varchar,@starttime,120)+''' and '''+convert(varchar,@finishtime,120)+''' '
exec(@sql)
declare @starttime varchar(10)
declare @finishtime varchar(10)
set @starttime='2007-07-01'
set @finishtime='2008-05-31' exec (' select ItemBH from Xfjd_check where Date_Created not between '''+@starttime+''' and '''+@finishtime+'''')
exec('select ItemBH from Xfjd_check where Date_Created not between '''+@starttime+''' and '''+@finishtime+'''') 可以了
但是怎么跟
select ItemBH from Xfjd_check where Date_Created not between 2007-07-01 and 2008-05-31
出来的结果不一样呢
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31'exec(' select ItemBH from Xfjd_check where Date_Created not between '''+@starttime+''' and '''+@finishtime+'''')
exec('select ItemBH from Xfjd_check where Date_Created not between '''+@starttime+''' and '''+@finishtime+'''')
跟select ItemBH from Xfjd_check where Date_Created not between '2007-07-01' and '2008-05-31'的结果是一样的,
declare @finishtime datetime
set @starttime='2007-07-01'
set @finishtime='2008-05-31' exec(' select ItemBH from Xfjd_check where Date_Created not between ''+@starttime+'' and ''+@finishtime+'' ')