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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-15 : 08:39:47
|
| Manish writes "Hi we are in the process of migrating our applications to SQL Server 2000. Our base platform is Oracle 9i. We have had smooth migration of Tables,Views,ProceduresFunctions etc. We are now stuck up with the migration of certain procedures in Oracle that return hierarchial data, by using the Oracle specific "CONNECT BY....PRIOR" construct. What do we do about this? I just want to know that, for a specific SQL Select statement with a Connect By clause, what do I need to do in SQL Server so that my functionality is preserved?Thanks a lot, in advance." |
|
|
SqlStar
Posting Yak Master
121 Posts |
|
|
|
|
|
Porting Oracle "CONNECT BY" Clause to SQL 2000 