converting from Oracle to SQL Server

From: cuneyt <member_at_dbforums.com>
Date: Fri, 22 Nov 2002 08:59:16 +0000
Message-ID: <2075941.1037955556_at_dbforums.com>

[Quoted] [Quoted] I have this Oracle Sql statement but I need to convert it to SQL Server Statement.
[Quoted] "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

Received on Fri Nov 22 2002 - 09:59:16 CET

This message: [ Message body ]
Next message: ben brugman: "Re: Oracle Client Installation on W2000"
Previous message: MePhi: "Re: RMAN online redo log restore issue"
Next in thread: tojo: "Re: converting from Oracle to SQL Server"
Reply: tojo: "Re: converting from Oracle to SQL Server"
Reply: Karsten Farrell: "Re: converting from Oracle to SQL Server"
Reply: cuneyt: "Re: converting from Oracle to SQL Server"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message