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 happens if date-only values are provided as date and time literals?

547


What are the difficulties faced in cube development? : sql server analysis services, ssas

611


What is the security model used in sql server 2005?

514


How to make a column nullable?

605


How to grant a permission in ms sql server using "grant execute" statements?

569






How we create SQL Server 2005 Reporting Services ? Give me Sample

1573


Explain about sql server login?

599


What are system databases into sql server (2005/2008)?

590


What are the steps to insert a table?

541


What languages bi uses to achieve the goal?

513


Explain system functions or built-in functions? What are different types of system functions?

571


What are Spatial data types in SQL Server 2008

556


What is de-normalization in sql database administration? Give examples?

540


What is a select query statement in ms sql server?

581


Define self join in sql server joins?

527