SQL To get Serial Number for each record

select identity(int,1,1) as Serial_Numbers,Ename,Sal into #tmptable from Emp
select * from #tmptable
drop table #tmptable