Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19555 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 is a dbms wizard?
What is a trigger what are the advantages of trigger?
What do you mean by an execution plan?
What is the log shipping?
Tell me what are the advantages of using stored procedures?
Can foreign key be duplicate?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the difference between a unique key and primary key?
Do you know what are the differences between lost updates and uncommitted dependencies?
Can we take the full database backup in log shipping?
How many types of objects are there?
Can a rule be bound to any column of any data type?
List the different types of collation sensitivities in sql server?
What is failover clustering overview?
Will the writetext statement activate a trigger?
