SELECT ROW_NUMBER() OVER (ORDER BY emp

how to get the rowid/rownumbes of a table in sqlserver

Question Posted / dhivakar

Answer Posted / dhivakar

SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In what three ways is the return statement used in a stored procedure?

989

What is optimization and its types?

953

Explain what are the restrictions while creating batches in sql server?

1045

What is the purpose of the master database?

1104

How to identify current user in ssrs report?

401

What are the operating modes in which database mirroring runs?

1062

What do you mean by sql server 2005 express management tools?

1288

What are the general features of sql server management studio? : sql server management studio

1060

Tell me what is sql profiler?

1012

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1145

Tell me what is difference between clustered and non clustered index?

931

explain declarative management framework (dmf) in sql server 2008?

973

What is 2nf example?

975

What is a view and what are its advantages?

1095

What are the different editions available in sql server 2000?

1029