how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / renu
Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Do I need a report server to run reports in my application?
How to create a view using data from another view?
Can we use where clause in union?
What are the dmvs? : sql server database administration
What are logical database components? : SQL Server Architecture
Where are stored procedures in sql server?
What is sql server transaction log file?
What is an execution plan?
What is the difference RDBMS and Graph Database?
How does using a separate hard drive for several database objects improves performance right away?
What is the native system stored procedure to execute a command against all databases?
what is raid and what are different types of raid configurations? : Sql server database administration
Explain sql server service broker?
What is dirty read?
What are the requirements on sql server network connections?