Please explain with the output (Example) that actually wants to list...

SELECT IDENTITY(INT,1,1) AS SNO, Name,address  into #tmp from <table name>

select * from #tmp