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

    Unanswered: converting from Oracle to MS SQL Server 2000

    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 04:51.

Posting Permissions

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