Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19745 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 have a nested transaction? : Sql server database administration
How many triggers are possible per table?
How to find the source of a table in sql server?
How do I edit a procedure in sql server?
What are the advantages of using cte?
How to drop an existing table with "drop table" statements in ms sql server?
How to declare and use cursor variables?
Write a sql query to delete duplicate records from a table called table1
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
whats the maximum size of view state??
how to determine the service pack currently installed on sql server? : Sql server database administration
explain how to create a new schema in a database? : Sql server database administration
How to update values in a table with update statements in ms sql server?
Do you know what are different types of replication in sql server?
Why transaction is important?
