Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19593 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
Is there any difference between the primary key and unique key?
Can coalesce return null?
What is difference between views and tables?
What are data resources?
What is query cost in sql server?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What do you understand by mirroring and mention the advantages of the mirroring?
What do you mean by an execution plan? Why is it used?
Name and describe few console utilities for ssrs?
How to create an multi-statement table-valued function?
What is the difference between dataadapter and datareader?
What is the security principal at the database level that represents your session?
How do I find my localdb version?
In which files does sql server actually store data?
How can we solve concurrency problems?
