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
How to update values in a table with update statements in ms sql server?
what is package and it uses and how can u call a package
what types of replication are supported in sql server? : Sql server database administration
Explain different types of index?
What is Lock table in SQL?
What is a join in sql?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is correlated subquery in sql server?
what are constraints? : Sql server database administration
What according to you is the difference between mysql and sql server performance?
Mention the 3 ways to get a count of the number of records in a table.
How to delete a login name in ms sql server?
List out the different types of locks available in sql server?
What are the features of Embedded SQL
Can you explain powershell included in sql server 2008?