how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 17319 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
Can we create clustered index on composite key?
Write a sql query to display the current date?
What are the new security features added in sql server 2012? : sql server security
Explain nested join?
What are the differences between user defined functions and stored procedures?
What do you understand by the denormalisation?
Explain forward - only cursors?
Write down the syntax and an example for create, rename and delete index?
What is the difference between a function and a trigger?
Write an sql query for deleting duplicate rows?
what is denormalization? : Sql server database administration
What is a partition key?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is the name of reporting services config file and what’s it’s used for?
Why do you want to join software field as you have done your BE in Electronics?
