how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 18130 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 the various types of concurrency problem?
What are the different subsets of sql?
List all types of constraints in sql server?
Tell me about joins in database system and explain each in detail.
Explain data warehousing in sql server?
Can the query output be sorted by multiple columns in ms sql server?
What is NOT NULL Constraint in sql server 2012?
How to test a dml trigger in ms sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
How can you manage sql azure security?
What are ddl triggers and types of ddl trigger?
What is system stored procedures?
What are drillthrough reports?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is user defined datatypes and when you should go for them?
