Re: converting from Oracle to SQL Server

cuneyt wrote:
> 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?
>
> --
> Posted via http://dbforums.com
Found this from Google ("Oracle to SQL Server: Migration Traps"):

http://asia.cnet.com/itmanager/netadmin/0,39006400,39043720,00.htm

Covers some functions, working with numbers, concatenation, etc. Received on Fri Nov 22 2002 - 18:37:02 CET