27,579
社区成员
发帖
与我相关
我的任务
分享
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0 from [' + @tablename1 + '] where test_datetime between ' + convert(varchar(30),@dt1,120) + ' and ' + convert(varchar(30),@dt2,120)
exec(@sqlstr)
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0 from [' + @tablename1 + '] where convert(varchar(30), test_datetime, 120) between ''' + convert(varchar(30),@dt1,120) + ''' and ''' + convert(varchar(30),@dt2,120)+''''
exec(@sqlstr)
@tablename1
这个从哪来啊?
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0 from [' + @tablename1 + '] where test_datetime between ' + @dt1+ ' and ' + @dt2
exec(@sqlstr)
--这样?
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0
from [' + @tablename1 + '] where test_datetime between ''' + convert(varchar(30),@dt1,120) + ''' and ''' + convert(varchar(30),@dt2,120)+''''
.
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0 from ['
+ @tablename1 + '] where test_datetime between '''
+ convert(varchar(30),@dt1,120) + ''' and ''' + convert(varchar(30),@dt2,120)+''''
exec(@sqlstr)
这样看看
set @sqlstr ='select sn, convert(char(10),Test_Datetime,120) as test_datetime,result into trxtemp0 from [' + @tablename1 + '] where test_datetime between ''' + convert(varchar(30),@dt1,120) + ''' and ''' + convert(varchar(30),@dt2,120) + ''''
exec(@sqlstr)
exec test '2009-11-12' , '2009-11-16'