How to achieve rowid of Oracle in SQL Server

Hot Topic

DTA Common Error and sp1
using exists with group by
Error when "SELECT" statement has conditions
Report Header
Object reference not set to an instance of an object
Oracle support and Report Builder
XMLA Queries in Execute SQL Task
Network access SQLExpress
P2P Replication Conflicts
backup failed

SQL Server

extracting sql table column names
Does anyone from MSFT monitor this forum anymore?
Even not pages printing in Reporting Services
How To Avoid Table Scan
Page Header on 1st Page ONLY
Schema related error
Set number of records per page globally without using ceiling
Log of rows inserted/updated/deleted
How to restore SQL 2005 DB to SQL 2000
Data Mining Tool

How to achieve rowid of Oracle in SQL Server

Hi:
How can I get the same function of rowid of Oracle in SQL Server.

thanks

Answer this question

How to achieve rowid of Oracle in SQL Server

  • Tony Harris

    Hi:
    How can I get the same function of rowid of Oracle in SQL Server.

    thanks


    Link

  • Amish Bandekar

    Just use MSSQL 2005. ROW_NUMBER() function (see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/82fa9016-77db-4b42-b4c8-df6095b81906.htm) is presented there.
  • How to achieve rowid of Oracle in SQL Server
Answer this question