how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 17342 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raman
If you want row id as ROWID in Oracle, use %%physloc%% to
get unique id for each row in a table.
Ex. Query to get physical address/rowid of first row in
table.
SELECT TOP 1 %%physloc%% AS ROWID FROM <UrTable>
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain filtered indexes?
How many types of objects are there?
Explain transaction server implicit?
Are null values the same as that of zero or a blank space?
between cast and convert which function would you prefer and why?
What command is used to create a database in the sql server and how?
What is coalesce in sql server?
How many types of triggers in sql server?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is the difference between seek predicate and predicate?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is page-level compression?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is report snapshot in ssrs?
