--创建临时表 #开头

create table #tempTest

(

Id int identity

)

select sno,sname into #b from a

select * from #b

drop table #b --删除临时表

--存储结果集with

with a as (select * from student)

select * from a