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


Please Help Members By Posting Answers For Below Questions

what are triggers? : Sql server database administration

673


What are different types of table joins?

767


What is @@error in sql?

813


Define magic tables in sql server?

770


What to check if a User database is locked?

787


Can sql servers link to other servers?

772


Where are sql server user names and passwords stored in sql server?

749


Find nth lowest salary or get nth lowest salary?

802


What are the common performance issues in sql server?

674


You want to use a perspective in an mdx query. How do you select the perspective?

187


What command do we use to rename a database?

787


How to create a simple table to test triggers in ms sql server?

697


What is code near application topology?

242


What is the size of transaction log file?

670


State a few properties of relational databases?

848