how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / payal nath
SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>)
FROM <TableName>
| Is This Answer Correct ? | 27 Yes | 5 No |
Post New Answer View All Answers
How is sql used in sql server?
How to insert multiple rows with one insert statement in ms sql server?
how will add additional conditions in sql?
How to provide default values to function parameters?
what protocol both networks use? : Sql server database administration
Explain iaas, paas and saas?
What is normalization 1nf 2nf 3nf?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What are the different types of replication are there in sql server 2000?
What is the security principal at the database level that represents your session?
What is abstracting periodical?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
is there a column to which a default can't be bound? : Sql server database administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Why use update_statistics command in sql server?