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

What are the approximate numeric data types?

533

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

497

Explain query editor regions

619

How do I find information about the install locations for the various instances running on a computer?

554

How does using a separate hard drive for several database objects improves performance right away?

530

what is normalization? : Sql server database administration

533

How can sql injection be stopped? : sql server security

554

What is single-user mode?

524

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

588

What is the difference between dbcc indexdefrag and dbcc reindex?

523

Call by value and call by reference in procedure and function, with NOCOPY.

839

How to receive output values from stored procedures?

483

What is the default sql server instance name?

560

What is an active database?

598

how can a database be repaired? : Sql server administration

518