Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19543 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vivek
Select Count(*) as ro_no from <tablename>
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Explain sql server service broker?
How can I tell if sql server is 32 or 64 bit?
What is difference between equi join and inner join?
What is the difference between char and varchar2 datatype in sql?
What is the difference between a local and a global temporary table?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Mention the different types of replication in sql server.
Explain atomicity?
How to fetch the next row from a cursor with a "fetch" statement?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is dynamic cursor in SQL SERVER?
What is enhanced database mirroring in sql server 2008?
what is difference between NULL and ISNULL in SQL Server 2008?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
