Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 need help for getting rowid

Author  Topic 

nilesh24
Starting Member

1 Post

Posted - 2014-03-12 : 03:04:45
Hi All,

I am working on the conversion of Oracle to sql server database.

While converting I am facing an issue with the rowid column which is present into the procedure of Oracle database and it is not available into the sql server.

Please provide me the help for the same.Thanks in advance.

Mar
Starting Member

47 Posts

Posted - 2014-03-18 : 09:06:34
You can create a column in the SQL server tables and insert the rowid from oracle into this new column.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-03-21 : 03:27:17
Alternatively you can make use of row_number() function to simulate rowed in SQL Server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -