converting from Oracle to SQL Server
From: cuneyt <member_at_dbforums.com>
Date: Fri, 22 Nov 2002 08:58:21 +0000
Message-ID: <2075939.1037955501_at_dbforums.com>
Date: Fri, 22 Nov 2002 08:58:21 +0000
Message-ID: <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?
-- Posted via http://dbforums.comReceived on Fri Nov 22 2002 - 09:58:21 CET