Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    59

    Unanswered: converting from Oracle to SQL Server

    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?
    Last edited by cuneyt; 11-22-02 at 05:12.

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: converting from Oracle to SQL Server

    Originally posted by cuneyt
    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?
    Don't you think that asking this to the SQLServer forum can be a better path to the solutions ?

    Good Luck.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  3. #3
    Join Date
    Nov 2002
    Posts
    59
    I've already did

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •