大家可以在自己的数据库上执行类似的语句,看看结果吧!
select top 30 * from data where kind_no LIKE TP%order by kind_no;
exec(select * into #data5 from data where data.kind_no LIKE TP% order by kind_no ;select top 30 * from #data5)
select top 30 * from #data5
================>
select top 30 * from #data5 order by kind_no