how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 18269 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
What command do we use to rename a db, a table and a column?
Some queries related to SQL
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Explain the first normal form(1nf)?
Explain user defined functions?
What is difference between oltp and olap?
What area unit the various kinds of info compression introduced in sql server 2008?
How to create a simple stored procedure in ms sql server?
Explain important index characteristics?
Why functions are used in sql server?
What is data source document?
How to get the definition of a stored procedure back?
Explain different backup plans?
What is SubQuery in SQL Server 2008
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
