select的一个问题。（在线等待）

Question

select identity(int,1,1) items,* into # from price
select * from #go
dorp table #

Answer 1

select identity(int,1,1) items, * into #t from price
select * from price

Answer 2

select identity(int,1,1) as items,* into #t from yourtable
select * from #t
drop #t

Answer 3

select identity(int,1,1) items, * into #t from price
select * from #t

Answer 4

select identity(int,1,1) items, * into #temp from price
select * from #temp

Answer 5

select IDENTITY(int, 1,1) items, product, price, number into #temp from price
select * from #temp order by items
drop table #temp