SQL code: select *,cast(bin as decimal(10,2)) as bin2 into #tmp2 from MyTable where convert(varchar(10),[Time],120) between '2009-07-01' and '2009-10-28 23:59:59' order by bin2
其中bin字段为varchar，不过其值能转换成2位浮点小数。
1.如上一个SQL，我想在查询分析器运行的时候查看（打印、调试）#tmp2的数据，有没有办法？
2.按照我后面一连串的勉强推测，貌似插入到#tmp2表的数据根本没有经过order by bin2排序，更不知有没有经过where的条件筛选，，，，，，，假若如我推测的话，有否解决办法？o select * from #tmp2
? print exec() up SQL code: create table #tt ( ID int identity(1,1) primary key, Bin varchar(10) ) insert into #tt select 'aa' insert into #tt select 'bb' insert into #tt select 'cc'
exec ('select * from #tt') ID Bin ----------- ---------- 1 aa 2 bb 3 cc
