SQL Server

how can i find rowid in Sql server database as like in oracle.

You can use row_number orderby one colums as below :

select row_number() over
(order by pk_idx_data_id) as rownum, empname,empsal from Employeetable