How to generate row number in SQL Server?

SELECT (SELECT COUNT(i.ref_no) FROM student_information i
WHERE i.ref_no >= o.ref_no ) AS RowID, sname AS 'Name' FROM student_information o ORDER BY RowID;