Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19540 Views
- IBM, I also Faced
- E-Mail Answers
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 get a list of columns using the "sys.columns" view in ms sql server?
What is global temp table?
What are the different types of stored procedures?
Explain the dbcc pintable command when would you use it?
What do you know about normalization and de- normalization?
What is rolap and its advantage? : sql server analysis services, ssas
How to convert a table data in XML format in sql server?
How to filter out duplications in the returning rows in ms sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Which is the latest version of sql server and when it is released?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain the use of keyword with encryption. Create a store procedure with encryption?
Do you know what is openxml in sql server?
Can foreign key be duplicate?
what is the sql equivaent of the dataset relation object ?
