mssql rownum 사용하기

select identity(int ,1 ,1) as rownum, a.* into #temp from [tablename] a;

select * from #temp;