[DotNetDevelopment] Check The Records-SQL

[san]

 How can i get the  row number in which record is stored in sql server.

Example: suppose if record is stored in fifth row i want output as 5.

Thanks!