Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19277 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 auditing in sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Explain view in sql server?
What are the properties of the transactions?
What is system stored procedures?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What do you understand by mirroring?
What is 'Join' and explain its various types.
Explain primary key in sql server?
How to attach adventureworkslt physical files to the server?
What is an inner join?
What is the process of indexing?
What is field in algebra?
What Are the Main Features of SQL Azure?
