Re: converting from Oracle to SQL Server

There is no easy way to convert the hierarchical query COONECT BY
to SQL server T-SQL.

I would suggest that you search the SQL server newsgroups for the solution.

• Jusung Yang

cuneyt <member_at_dbforums.com> wrote in message news:<2075939.1037955501_at_dbforums.com>...
> I have this Oracle Sql statement but I need to convert it to SQL Server
> Statement.
> "SELECT LPAD('-', 2*(LEVEL-1),'-') || DESCRIPTION DESCRIPTION,
> LEVEL_CODE
> FROM T_NBS_LEVELS"SQLStr=SQLStr&"
> START WITH PARENT_CODE = 0"SQLStr=SQLStr&"
> CONNECT BY PRIOR LEVEL_CODE=PARENT_CODE "
>
> Sql Server gives Run time error message which is about LPAD is not
> recognized etc...
>
> Also does anybody know a tool that converts Oracle Sql statements to SQL
> Server Statement?
Received on Fri Nov 22 2002 - 18:00:52 CET