Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19338 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
State the difference between local and global temporary tables?
How do I start sql server 2017?
What is snapshot replication?
How can we remove orphan records from a table?
What is function of ROLLUP ?
explain different types of backups avaialabe in sql server? : Sql server database administration
What is the difference between varchar and nvarchar datatypes?
Explain what are the authentication modes in sql server?
What new changes are being made in SQL Server?
Explain what is meant by replication of database?
Can primary key be null?
What is self contained scalar sub query?
How to drop existing indexes in ms sql server?
Can a table be moved to different filegroup?
Describe the functionalities that views support.
