get the serial no. for records of table in sqlserver

select empname, row_number() over(order by empid)as 's.no' from tblEmp