how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / dhivakar
SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In what three ways is the return statement used in a stored procedure?
What is optimization and its types?
Explain what are the restrictions while creating batches in sql server?
What is the purpose of the master database?
How to identify current user in ssrs report?
What are the operating modes in which database mirroring runs?
What do you mean by sql server 2005 express management tools?
What are the general features of sql server management studio? : sql server management studio
Tell me what is sql profiler?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Tell me what is difference between clustered and non clustered index?
explain declarative management framework (dmf) in sql server 2008?
What is 2nf example?
What is a view and what are its advantages?
What are the different editions available in sql server 2000?