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
Explain a join?
What type of Index will get created after executing the above statement?
Are connections to sql server encrypted?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to get @@error and @@rowcount at the same time?
How to remove duplicate rows from table?
What do you mean by stored techniques? How would we use it?
what are database files and filegroups? : Sql server database administration
When you use @@error and try-catch?
Can we use where clause with group by?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is explicit mode in sql server?
Explain DBCC?
Can foreign key be duplicate?