how to get the rowid/rownumbes of a table in sqlserver
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 is primary key index?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Describe how to use linked server?
How many columns can we include on clustered index ?
what is a schema in sql server 2005? : Sql server database administration
How to retrieve error messages using mssql_get_last_message()?
What is read committed?
What is the difference between dropping a database and taking a database offline?
How to fetch the next row from a cursor with a "fetch" statement?
What programming language would you use to create embedded functions in ssrs?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Does server sql treat char as a variable-length or fixed-length column?
How do you size a resultset?