how to get the rowid/rownumbes of a table in sqlserver
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
ow to bring suspect mode datbase online from scratch
What is replication with database mirroring? : sql server database administration
Explain the purpose of indexes?
What is instead of trigger sql server?
What is surrogate key? : sql server analysis services, ssas
What is query processing?
List the different types of collation sensitivities in sql server?
Why variables called the most powerful component of ssis?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
List the different types of joins?
What is clustered index
How is sql server used?
How to modify existing triggers using "alter trigger"?
What is the synonym of join?
Mention the different authentication modes in sql server.