Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19280 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
What were the latest updates to SQL Azure service?
What is the difference function and stored procedure?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Is foreign key unique?
Define a cross join?
How many types of triggers are there?
What is a primary key?
Can group by be used without aggregate functions?
What is the difference between clustered and a non-clustered index?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Can two tables share the same primary key?
How can you append an identity column to a temporary table?
What is acid db?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain system scalar functions?
