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
What type of locking occurs during the snapshot generation? : sql server replication
What is the command used to check locks in microsoft sql server?
Explain the dbcc pintable command when would you use it?
How many types of triggers in sql server?
How you can change a cross join into an inner join?
What is merge statement?
Can we call future method from trigger?
How to turn off warning messages during php execution?
What is the maximum size of column in sql server?
How to create indexed view?
Can we add our custom code in ssis?
When I delete any data from a table, does the sql server reduce the size of that table?
Which is the latest version of sql server and when it is released?
What is an index in sql?
What is a rownum?