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.
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. |
|
|
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 ServerMadhivananFailing to plan is Planning to fail |
|
|
|
|
|